October 5, 2011 at 1:06 pm
Hi all,
I'm planning to migrate 15 tables from a database(sitting on one server) to a database (sitting on another server). So, after migrating data from 1 table it should proceed with the 2nd one.
I'm guessing I should use Foreach loop container but not 100% sure.
The data flow task is simple-- OLE DB source to OLE DB destination.
Can someone please tell me how do I use for each loop container to automate the process for all 15 tables? SInce I'm very new to SSIS, I'd really appreciate if you could explain in detail.
Thank you.
October 5, 2011 at 2:38 pm
That's probably more complicated than it needs to be. You could use the import/export wizard by right-clickig on the source database and choosing Tasks > Export Data. It might be good to create the tables and any indexes, etc. in the destination database first. You could save the package for future use.
October 5, 2011 at 2:50 pm
Using import export for multiple tables, I saved the package.
But I want to know if it would really hamper the performance since the tables that I'm going to export are really really big...Few of them are more than 400GB each.
October 7, 2011 at 9:36 am
You might want to consider doing it in two steps then. First, set up the table schema on your new system, and then use a bulk load to transfer the data across.
** EDIT **
though for that matter, I wonder if that's what the import/export wizard does anyway.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply