December 2, 2009 at 7:39 am
Hi all,
I am looking for some info and have been trauling the t'internet but maybe stretched my eyes a bit too far and wide, and have missed the answers.
Can the same package be run simutanously as x number other instances of itself? I am starting to think yes...
My setup is SSIS on the same server as SQL with packages in the file system. I am a bit of a newb with SSIS but have been trying to cram in as much info as possible.
If a package is executing at the same time as an instance of itself this could mean issues with the exports I will be doing, as well as any staging areas involved with said package.
Please help my brain un-fuzz!
Many thanks
Kevin
December 2, 2009 at 9:21 am
I think there are several things in play here. From SQL Agent if you have a job that calls a package it will only run one at a time. With that said if you have a package that has several EXEC package tasks you could have a package running in several instances. With that said if you have a process that shouldn't run more than one copy you should control how it is called.
What I mean by this is that if you have a process that having more than one copy running at a time would be problematic then doing something like calling DTExec through xp_cmdshell in a sproc to start it would be a bad idea, why? Because that could cause more than one copy to be running at a time. To resolve this particular example I would probably create a SQL Agent job to call the SSIS and use the sproc to start the job, that way if it is already running it won't start a second copy.
However there really is nothing that truly prevents having more than one instance of a package running. You could build some mechanism but it is probably more trouble than it is worth..
CEWII
December 2, 2009 at 9:44 am
Hi Elliott,
I am still not sure exactly how we're going to be running the SSIS packages at the moment, we've got a production team who will be running the packages, though probably will only have them doing it through the SQL Agent.
It's early days for us with 2008 and SSIS (jumped from 2k). We've nothing live as yet and just wanted to make sure I was on the right path to avoid some of the pitfalls.
Thanks very much for the info. Appreciated.
Kevin
😀
December 2, 2009 at 10:01 am
You are very welcome. That leap is quite steep the first time..
CEWII
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply