I am using BIDS / SSIS 2005. I have a large package that runs very smoothly and fairly quickly when run in debug-mode through BIDS. When I actually deploy the package to SSIS and execute it using either DTExec or DTExecUI it is WAAAAYYY slower
than when run from the development environment. So slow that I become convinced it is hanging on steps that execute very very quickly in BIDS. I have read this thread -> http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/5585fa13-dd15-4406-9d4a-e993f2af5929
which has not helped.
I understand that DTExec would be faster than DTExecUI because the former does not have to deal with the GUI component but I would have expected both (and especially DTExec) to be faster than running in debug from BIDS.
I realize I am not providing a ton of detail here, problem is I just don't know where to start... any advice on what I should be looking at to improve package execution through DTExec and / or DTExecUI would be greatly appreciated. Why would DTExec
be so much slower than BIDS Debug???
Thanks in advance..
View Complete Post