Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Monday, December 08, 2008 6:15 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:06 PM
Points: 182, Visits: 691
Hi,

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.

Chris
Post #615860
Posted Tuesday, December 09, 2008 5:55 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,732, 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