Deployed package don''t have correct connection string...

  • I had designed my package using VS and under connection manager  I had preconfigured the login user and password to connect to my databases.

    However, after I build the SSIS package and deployed my SSIS package through file system and using DTEXEC command to execute my package.  It complaints and error "Failed to acquire connection....connection may not be configured correctly"

    Any idea, why that is??  Help?

    DBA/OLAP Developer -
    San Francisco, CA

  • Hi,

    This is likely to be down to the ProtectionLevel property on your package. This might help or give you a better understanding of how the package security works.

    http://support.microsoft.com/kb/918760

    Regards

    Daniel

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

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