"thabrown" wrote:

> Hi,
> I'm using SQL2005 SSIS designer to create a package that contains an FTP
> task. I can set the FTP Connection properties in the designer okay and
> manually run my package, but when I create as a scheduled job on SQL 2005 it
> fails with "-1073573489,0x,Unable to connect to FTP server using "FTP
> Connection Manager".
>
> I'm assuming the package does not retain the user name and password I put in
> the designer's FTP Connection Manager Editor.
>
> Can someone explain how to retain such credentials for a job? How to create
> an external properties file perhaps that has the login info? Searching for
> similar posts, besides the SSIS designer FTP Connection properties, there is
> mention of programmatically setting password properties -- however, I am not
> a C# or .NET programmer and am hoping for an easier solution.
>
> Any suggestions much appreciated.
>
> Thank you,