Post reply

SSIS config file with multiple connections

  • August 31, 2010 at 4:14 am

    #227055

    Hi,

    I need to store multiple connection string in one configuration file, and from a single package using the connections from that file, one by one fetch data from different locations.

    How can be that done?

  • August 31, 2010 at 7:04 am

    #1214244

    You would set up each connection in the SSIS Package Connection Manager. Then run the SSIS Package Configurations wizard. It will display the connections you have defined and allow you to select the connection strings you wish to save to the config location.

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

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