Source Table

[Former Member]

Hello everyone,

I have 10 source tables but the operation i am going to do with that is common. I dont want to have 10 different transforms to perform the same action.

Is there any way i can pass the table name over run time ? so that all my work will be done in one go.

Any leads ?

Thanks,

AJ.

[Former Member]

Hi Arun,

One  way to do this is to use an SQL transform as the source and specify the table name as a variable in the SQL string.  For each iteration of the dataflow - parse the table name to be used in the SQL string.

Hope this helps,

Ian.