Please start any new threads on our new site at https://forums.sqlteam.com. 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 

Analyzer
Posting Yak Master

115 Posts

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

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 -