Post reply

Connection strings on a deployed package

  • January 20, 2009 at 7:09 am

    #383762

    I got a production system where SSIS package is deployed.

    I see a job which runs the package (.dtsx) file on a directory.

    when i open the file i see source & destination connections strings.

    But they are not valid, the servers specified there, does not exist.

    Where can i find the connection strings on a package deployed in production ?

  • January 20, 2009 at 10:26 pm

    #930091

    snowshan (1/20/2009)

    I got a production system where SSIS package is deployed.

    I see a job which runs the package (.dtsx) file on a directory.

    when i open the file i see source & destination connections strings.

    But they are not valid, the servers specified there, does not exist.

    Where can i find the connection strings on a package deployed in production ?

    Check your SQL Job step setup on your server. It should contain parameter pointing to the package configuration.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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