InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 01:22:30 GMT20http://www.sqlservercentral.com/Forums/Topic615860-148-1.aspxYou cannot save the password in the package - it is a security measure taken in SSIS. Look up "package configurations" in books online. You can create a configuration file with the connection string (or even just the password) that you can use for the execution of the package.Tue, 09 Dec 2008 05:55:59 GMTMichael Earl-395764http://www.sqlservercentral.com/Forums/Topic615860-148-1.aspxHi,I deployed SSIS with dtutil utility. Package tried to copy data from Oracle to SQL 2005 and got an error: ....."The AcquiredConnection method call to the connection manager "server.user" failed with error code 0xC0202009. There may be error messages posted before this with more information"It seems to me connection manager did not get saved. Is there a way I could save the password in package? Thanks.ChrisMon, 08 Dec 2008 18:15:01 GMTChris Lee-152270