0

I'm consolidating the information of 7 SQL databases into one. I've made a SSIS package and used Lookup transformation and I managed to get the result as expected.

The problem: 30 million rows. And I want to perform a daily task to add to the destination table the new rows in the source tables.

So it takes like 4 hours to execute the package...

Any suggestion ? Thanks!

I have only tried full cache mode...

June7
  • 19,874
  • 8
  • 24
  • 34
Luis Tomé
  • 1
  • Help me understand. Why is 30 million rows a problem? Why is 4 hours a problem? What does the data flow actually look like - Screenshots are invaluable for SSIS packages – billinkc Dec 09 '22 at 18:04

0 Answers0