Post reply

SSIS Package Iterative Connection question

  • June 25, 2009 at 12:41 pm

    #211270

    I'm creating a little schema structure that gathers information from databases on multiple servers in the environment. I'd like to make a list table with Server names to iterate through when connecting to the different SQL Servers.

    Anyone have any ideas how to do a for loop in SSIS that re-writes the connection string on the fly?

    Any thoughts would be appreciated.

    Thanks,

    Brodie

  • June 25, 2009 at 10:17 pm

    #1015754

    bbrickey (6/25/2009)

    I'm creating a little schema structure that gathers information from databases on multiple servers in the environment. I'd like to make a list table with Server names to iterate through when connecting to the different SQL Servers.

    Anyone have any ideas how to do a for loop in SSIS that re-writes the connection string on the fly?

    Any thoughts would be appreciated.

    Thanks,

    Brodie

    Check this discussion. You have to do something similar, but modifying ConnectionString property with expression.

    ---
    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