Posted by jags_32 on 11/20/07 21:24

We have a pretty simple data flow that fetches data from our Source
ERP system and dumps it into a SQL Server table. This functionality
works, what we are trying to do now is to extend this functionality by
looping through a table in SQL Server which has a list of all ODBC
connections, changing the source connection dynamically. How do I do
this? For some reason, the SQL Server online tutorial is useless since
it just deals with file looping.

Appreciate any feedback.

Thanks

Jagannathan Santhanam

[Back to original message]