Specifying server name in DTS Pkg

  • Can someone help point me in the right direction on this...

    We are wanting to push 1 table out to the same database in a list of servers that is contained in a table in a database.  The thought was we could retrieve a list of the servers into a recordset and for each record in the record set create a datapump task to push out the table.

    I was curious if there is a good reference for doing the recordset/looping with Active X.

    Any help is appreciated

    -Erich

  • I feel you can manage that in several ways. What is the size of you table and are the same in same location (I meant how good is your network bandwidth)

     

     


    Kindest Regards,

    Amit Lohia

  • Very small table listing only 100 - 200 servernames

  • I mean the table which need to push to all the servers


    Kindest Regards,

    Amit Lohia

  • Very small less than 1000 records

  • I don't have time to tell you how to do it, but I would look at using the Dynamic Properties task to set the destination server name.

    The following link demonstrates how to create a loop using ActiveX tasks

    http://dbforums.com/t528282.html

    In the past I have also used the dynamic properties task to perform the looping.

    Hope this helps

    Steve

    Stephen Bailey

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

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