Hi,

I have one SSI package was created 4 years back; Which is very slow in design 

mode after i moved the package into other new system(32GB RAM,1TB harddisk,x64 

windows). There are other SSIS projects running on the same system does not have 

this issue. The same package is faster in old system.


The package contains 5 data flow task.
Which load data from excel sheet and SQL server database. average number of rows 

loading is 10000.

I have tried by removing some dataflow task to another new package, but still 

slow.

Please advise. 

10000 is not that big a size. Are those local xls sheets or from a remote shared server? Is it macros enabled (xlsm)? WHats is the provider (connection manager) used for the Excel? are the data flow tasks running in parallel? Are multiple data flow tasks accessing same resource (table)? 

Does tables have clustered index or are they heap tables? Whats the avg size of tables now?