How to deploy SSIS package with connection manager password?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » How to deploy SSIS package with connection...

How to deploy SSIS package with connection manager password?

Rate Topic

Display Mode

Topic Options

Author

Message

Chris Lee-152270

Posted Monday, December 08, 2008 6:15 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 16, 2013 5:34 PM
Points: 182, Visits: 609

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

Michael Earl-395764

Posted Tuesday, December 09, 2008 5:55 AM

SSCrazy

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 »

Permissions