|
|
|
Grasshopper
 
Group: General Forum Members
Last Login: Wednesday, August 25, 2010 7:56 AM
Points: 12,
Visits: 394
|
|
I'm having nearly identical symptoms with a step in a DTSX package (search SQL Server Central forums for "DTSX package step stalls"). It's really frustrating since it impacts the entire package.
Any help on this issue is greatly appreciated.
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: Thursday, June 10, 2010 8:05 PM
Points: 200,
Visits: 298
|
|
This thread didn't go anywhere because the Original Poster only provided some of the information that I needed to understand what was going on.
Please post the following information, starting with the name of the transform that is slow:
Tim Wilson-Brown (4/8/2009)
Can you post CREATE Table statements and create index statements for the source and target tables, and a screenshot of the data flow that's causing the problem.
Can you take a screenshot of the data flow when it's paused as well?
Can you also give me an idea of the number of rows that the data flow processes.
Tim Wilson-Brown (4/13/2009)
When the package pauses, which transforms (inside the data flow task) are green and which are yellow?
Did the package run any faster when you scheduled it as a SQL Server job?
Edited to remove unnecessary comments from quotes.
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Wednesday, August 25, 2010 7:56 AM
Points: 12,
Visits: 394
|
|
OK. I got mine to perform more like expected.
On the DTSX step (Data Flow Task), I changed the DefaultBufferSize from 10485760 to 40485760.
Total execution time went from 20 minutes+ down to 6 seconds.
I hope this helps someone else.
|
|
|
|
