Post reply

QUestion on how to loop through several SQL Connections

  • May 14, 2009 at 8:41 pm

    #137830

    Hi all my name is Ryan, since I'm new in SQL Server Integration Services Technologies I have some question.

    For example I have three database servers, all of them using IP numbers for their server name to connect. Lets name it IP1, IP2, IP3. What I want to know is how can I loop through those IP of server connections to do some task, like moving one table data to the other table in destination server. Could it be done ????

    can you guys help me do this, if I'm not clear enough 'bout my problem please let me know 'cause I wanna get this one done, thanks for all the help.

    Best Regards,

    Ryan

  • May 14, 2009 at 10:01 pm

    #995045

    The Foreach container is designed for this sort of task. You use the foreach container to iterate through the list of IP addresses (perhaps as data in being returned from a SELECT statement)

    You use an expression to assign the address to the name of the server for the connection you are using as the source for your data.

  • May 15, 2009 at 2:02 am

    #995132

    hi, thanks for happycat59 for the reply.

    I quite understand 'bout your explanation for my problem, but can you give me the details about the steps from your explanations, because I still confused without some detailed steps. Thank you, sorry if my noob behaviour is disturbing, I'm still learning hehehehe...:-D

    Regards,

    Ryan

  • May 15, 2009 at 3:13 am

    #995171

    There is an example here

    http://www.sqlservercentral.com/articles/SSIS/61987/

    and another one here

    http://www.sqlservercentral.com/articles/SSIS/64014/

    neither one will be 100% match for what you want but they should give you enough info 😉

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

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