Concurrency and .DTSX files
-
Quick question - I have a server running with two named instances on it. If I have a single .dtsx file that I want to access as a job from the two instances (with different config files supplied in the command line) will I run into any concurrency issues?
Cheers
Andy
-
It depends I guess
It depends on what you're trying to do in your package. If you write/delete twice to the same table, then maybe yes, there will be some issues if the package is run twice at the same time.
I have a package that behaves differently according the value of a package-level parameter. I have two jobs that call this package at the same time, each with a different value of that parameter. It works like a charm, no problems at all. However, the configuration is always the same, unlike your example, but I don't expect much troubles...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply