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 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 |
|
|
|
|
|
Dynamically Build Column Mapping Strings