May 16, 2012 at 10:55 pm
We have a job to execute SSIS packages. if we initiate a second request following the initial one the first one will complete, and the most recent one will be stalled out. Then, if we initiate another request, that pending one will flow. Any input what is happening?
Cheers,
Got an idea..share it !!
DBA_Vishal
May 17, 2012 at 4:02 am
That's going to depend entirely on the logic within the SSIS package. I would assume you must have some conditional logic or wait conditions that can never be satisfied, or you're causing a hang by (for e.g.) moving a file that the other package is trying to read.
If you haven't designed your SSIS package to run correctly when multiple instances are running, then don't run them together or put a process in place that prevents it occuring (e.g. a lock table or starting the package via a SQL Agent Job)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply