Dynamic mapping in dataflow: For copying multiple tables

[bsamsani]

Hi all,
Im trying to copy data from multiple source tables to multiple destination table.
I need to get it done in dynamic way, means using For Each loop I want to traverse all the table, and process each table at once, For this I'm facing problem in mappings.

For the first table it was working fine, but in for each loop in the second table it giving error due to invalid mapping.

Please help me on this.

 

[MDXer]

You can't dynamically map source and destination columns, in the way it sounds like you are trying. If you have to move data from multiple source tables to multiple destination tables then you use either multiple dataflows or multiple packages.

If you have lots of tables you have to move then you have lots of packages to create.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck