FTP task executes ok in BIDS. Password for FTP server is hard coded in the FTP task .
When I scheduled this package as a job in SSMS it fails because the password blanks out . SQL agent errors out with The login request was denied . Any inputs how to keep the password in FTP within SQL Agent?
Crap....this may be one of those "feature by design" and the save password option is only good for the duration of the BIDS session at least when ProtectionLevel=DontSaveSensitive
The KB below describes
My client sends a request to me that they want me to load data, which will be returned by Web Service APIs, and do some transformation before importing to database. In this article, I will provide an approach to load data with Web Service Task and X…