Post reply

How to deploy SSIS package with connection manager password?

  • December 8, 2008 at 6:15 pm

    #194848

    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

  • December 9, 2008 at 5:55 am

    #909573

    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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply