Wednesday, March 21, 2012

Multiple Executions of same package using DTEXEC

Hi,

I have a file-deployed package which I need to call N times at once using DTEXEC. When I attempt to execute N instances of the package, the second instance doesn't execute. I can execute different packages at the same time, but never the same package more than once. Does anyone know how to get this scenario working? Just to clarify a bit more - I can call the package as many times as I like as long as I wait until the previous run of DTEXEC is finished. Please help!

Thanks,

dcb99

I have accomplished similar results but calling the package from another package. You could use a Foreach loop; but that will not allow you parallel executions, though. In my case, I used multiple execute package tasks pointing to the same package; which BTW I don't think is the best approach but the only one I could figure out without writting custom code.|||How about writing a .NET console app to execute the packages?

No comments:

Post a Comment