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

• Next in forum: Re: query performance help needed
• Prev in forum: Saving changes
• Thread view: FOREACH LOOP container and looping through record set ...

[Reply to this message]