Wednesday, January 02, 2008 4:46 AM
Wednesday, January 02, 2008 8:08 AM
Have you considered using an XML configuration file ?
If not , you should . It will ease you SSIS deployemnts and make your packages portable .
You should also store you configuration files in a standard locaion .
Look here for more info http://msdn2.microsoft.com/en-us/library/ms141682.aspx
Wednesday, January 02, 2008 8:10 AM
U have to Manually enter password in config file.It will not take automatically.
Wednesday, January 02, 2008 2:13 PMModerator
You can use package configuration to make your package 'portable' across servers.
This is the BOL topic, nut there are tons of extra info in this forum and on the web
This KB article covers some common issues when running packages via SQL Server agent and some considerations when deploying packages: