SSIS package moving very slow...

[dmando84]

Hello,

I have an SSIS package that basically truncates all tables in a destination database, (over 250 tables) and reloads the same tables from a different, (yet identical) database.
The database size is approximately 8GB. This process is taking over an hour to run. Does anyone know if there is a property or something of that nature that could speed up my SSIS package?

Thanks,

David

 

[FlaBusInt]

I'm pretty new to SSIS myself, but I am trying something similar to what you do, albeit with somewhat fewer tables.

Can you see where the bottleneck is? Is it in the truncation or (I suspect) the reload?

What source and destination drivers are you using to load the data?

 

[MDXer]

Are you moving data for all tables in a single Data Flow?

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[dmando84]

Hello,

I am not using Data Flow, I am using Control Flow. Is there a difference in performance?

David

 

[LNBruno]

Definitely should check out this thread1555-1368466

< M!ke >

 

[FlaBusInt]

Are you loading the tables in sequence, or in parallel?