Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Dynamically Build Column Mapping Strings

Author  Topic 

Posting Yak Master

115 Posts

Posted - 2015-03-31 : 06:05:37

Migrating 800 tables (1.5TB) from Teradata to ss2014. Need to figure out the most optimal method to enumerate each table, its individual column mappings then extract - map columns- load data into ss2014.

Please advise do I:
1\Using For Loop Container loop over list of tables
2\Using expressions build a column mapping list per table - if so please advise on "steps"
3\Extract data and load into ss2014
4\ Run multiple packages in parallel for performance

Any ideas would be gratefully excepted. Thanks

- Advertisement -