Post reply

In SSIS Package-changing connection string.

  • June 1, 2009 at 3:23 am

    #210215

    hi,

    inssis package (execution package utility) how can i change the connection string in connection manager.if edit the connection string it is not affecting the result.

    please help me.

    🙂

  • June 1, 2009 at 4:30 am

    #1002637

    not a lot to go on...but do you have a config file setup for the package? If so what is the connection specified to in that file. If it is set to the problem connection string, try changiong it in the config file to the correct path and re-run the package.

    Gethyn Elliswww.gethynellis.com

  • June 1, 2009 at 6:33 am

    #1002700

    thanks,

    actually that is my issue. how can i create a configfile( server settings) for the ssis package.

    my scenario :

    i have created a package locally and now i want to execute that package in another server.for that ihave to create a configfile according to that server.

    🙂

  • June 1, 2009 at 9:47 am

    #1002854

    You can create a config file for a package

    Opening the package in BIDS

    Right click the package work area

    Select Package configurations.

    Its probably worth having read of BOL:

    http://msdn.microsoft.com/en-us/library/ms137900.aspx

    This talks about config files and deploying ssis packages

    Hope it helps

    Gethyn Elliswww.gethynellis.com

Viewing 4 posts - 1 through 3 (of 3 total)

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