Serge Mirault (2/22/2011)
Thanks for the reply Craig. This only shows the execution times and steps for everything "after" the build process completes...which runs exceptionally quick (< .5 secs)
It's the actual build that's taking several minutes.
Any ideas on the build aspect?
Hm, another brainfart for me, you're right, it doesn't
show times for the validation components.
I assume you do see things like this, in particular the Validation component?
Task Data Flow Task 2
Validation has started (2)
Progress: Validating - 0 percent complete
Progress: Validating - 100 percent complete
Validation is completed (2)
Start, 1:44:44 PM
Finished, 1:44:44 PM, Elapsed time: 00:00:00.094
If some of those break down to 10% increments or the like, that'll be a hint. Also, in your Output tab (after you run it once), you'll see a dropdown that reads as debug. If you switch it to build, do you get anything other than:
Build started: SQL Integration Services project: Incremental ...
Build complete -- 0 errors, 0 warnings
- Craig Farrell
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake. For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally TablesTwitter: @AnyWayDBA