September 15, 2005 at 1:16 pm
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
September 15, 2005 at 3:11 pm
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)
Amit Lohia
September 15, 2005 at 3:18 pm
Very small table listing only 100 - 200 servernames
September 15, 2005 at 3:19 pm
I mean the table which need to push to all the servers
Amit Lohia
September 15, 2005 at 3:32 pm
Very small less than 1000 records
September 16, 2005 at 3:04 am
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