|
|
Posted by jags_32 on 11/26/07 00:34
J
Could you elaborate on step 5?
Thanks
Jagannathan Santhanam
On Nov 21, 8:50 am, jhofm...@googlemail.com wrote:
> HiJagannathan,
>
> 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]
|