September 19, 2008 at 5:15 am
Hi ,
In my scenario,I am geeting list of servernames(csv file). then I am loading these files in to one destination using script task and foreachcontainer.Now my problem is in runtime i want to create corresponding destinations dynamically.Any suggestions highly appreciable
Thanks
September 21, 2008 at 10:47 pm
If you mean changing into corresponding destination connectionstrings from available servernames (csvfiles) you can change the connection strings in script task itself right?
September 22, 2008 at 1:55 pm
Have you thought of using a multicast and assigning the value for each destination by using a script task? If, on the other hand, you have a dynamic number of destinations - how about assigning the list to a recordset, adding it to an object variable and then putting it into a forEach loop based on that variable and using a script task to assign the appropriate destination to your connection from the recordset for your data transformation
hth
Andrew
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply