Viewing 2 posts - 1 through 2 (of 2 total)
Delete the file connection from connections and save the package and close it and again open it and recreate the file connection and connect in pipe line.
It will work with...
July 29, 2008 at 1:56 am
#849595
You can save the passwords in SSIS Package to be deployed on another server.
The procedure is simple, while deploying the package to remote server on msdb on SQL Server.
1....
July 29, 2008 at 1:18 am
#849579