Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

How to deploy SSIS package with connection manager password? Expand / Collapse
Posted Monday, December 8, 2008 6:15 PM


Group: General Forum Members
Last Login: Monday, September 19, 2016 12:45 PM
Points: 185, Visits: 802

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.

Post #615860
Posted Tuesday, December 9, 2008 5:55 AM


Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,661, Visits: 23,078
You 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.
Post #616059
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse