Multiple users Executing the same package

Question

My Scenarion :

I do have  SSIS Packages That are executing depending on the Line of business selected .(LOB)

LOB are selected from UI (a .Net Application) . from that the SSIS  package (SQL JOB) are executed .

SSIS packages loads the data from source to destination . and does some validation on the data

requiremet :

Now the requirement is to execute the same SSIS packages for the multiple users ..

Suppose the User1 selected the LOB - Retail and loaded the SSIS packages (data Load) and at the same time others users should be able to load th data or execute the same

Please suggest some possible way to execute the same package for Multiple users . or tell some best Possible way so that it can be implemented .
Do i need to keep Track of teh users loading the Files(.csv) and then execute teh same in sequence .Please suggest ...?????

Answer 1

Hi Rakesh,

this is not a desirable situation to allow users to run the same package in concurrent manner.

Instead the execution should be queued.

If you do insist on running the package simultaneously you will need to ensure the changes do not step on each other e.g. the tables involved are never locked in exclusive mode or the entire table lock is imposed, beware, this is hard to do with relational databases.

---

Arthur

MyBlog

Twitter

Answer 2

Hi Rakesh Dhar,

I think you could try to use DTexec tool with different user to execute the same package at same time.

In this scenario, SSIS will be capable of doing this and create multiple threads. Please check this similar thread: Concurrent run of a package

Check if this helps.

Regards,

Pirlo Zhang

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 3

refer following link

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/1161bc6b-b847-4609-92b0-27467be89027/multiple-users-trying-to-run-same-ssis-package?forum=sqlintegrationservices

---

Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem.