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.
| 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 tables2\Using expressions build a column mapping list per table - if so please advise on "steps"3\Extract data and load into ss20144\ Run multiple packages in parallel for performance Any ideas would be gratefully excepted. Thanks |
|
|
|
|
|
Dynamically Build Column Mapping Strings