Avatar of Nana Hemaa
Nana Hemaa
Flag for United States of America

asked on 

SQl Agent job fails--SSIS package looses password

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?
Microsoft SQL ServerMicrosoft SQL Server 2005SSIS

Avatar of undefined
Last Comment

8/22/2022 - Mon