|
Posted by jhofmeyr on 11/21/07 13:50
Hi Jagannathan,
You will need to:
1) Create a variable in the package of type "Object"
2) Put an Execute SQL task before your ForEach loop which returns the
connection data from your database and puts it into the variable you
created (Change the "ResultSet" property to "Full result set" and on
the Result Set tab set the Result Name to 0 and the Variable Name to
the new variable you created.
3) On the Collection tab of your ForEach loop, change the Enumerator
property to "ForEach ADO Enumerator" and set the ADO object source
variable to the Object variable.
4) On the Variable Mappings tab of your ForEach loop map your
connection details to suitable variable(s). *NOTE: These variables
will need to be at the Package scope.
5) Set Expression(s) using the variables set by the ForEach loop to
configure the ODBC connection manager that your data flow source task
is using.
It is important to note that the table metadata in each of the ODBC
databases needs to be identical in order to re-use the same data
flow. If the metadata is different then you will need to create a
seperate data flow for each table.
Good luck!
J
Navigation:
[Reply to this message]
|