I am new to SSIS.
I am planning to use SSIS for data migration. I have a big source table (record count: 35M). I would like to start the migration from old table to the new table before the actual release day. In that way, on the actual release day, the execution time is low.
How can I do that?
For example, today is April 03. And our actual release date is April 10. The source table has a record count of 35 Million (as of today). May be by April 10, it will grow up to 37 Million records.
Option 1: I can run the SSIS package on April 10, and it will have to take care of 37 Million records.
Option 2: Can I run the SSIS package on April 08 for records upto that point. and then run the package again on April 10 for the rest of the records?
If option 2 is possible, how can I do that?
Thanks in advance for your kind advise.