How do I run multiple stored procedure using ssis package at a time?

Question

0.00/5 (No votes)

See more:

I have around 15 procedures to be run at a time using ssis package. is it possible to run 15 'execute sql task' component inside the package .is there any restriction to use number of execute sql task parallely ?

What I have tried:

Now I have created the package I have taken sequence container inside that 5 execute task are placed I have not used president constraint between all tasks.kindly help me is it possible to add 15 execute sql task inside the sequence container.

Posted 3-Jan-18 20:38pm

Member 11337367

Updated 4-Jan-18 0:01am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RDBurmon · Accepted Answer · 2018-01-04T00:01:00

Solution 1

Yes its possible

Three ways to implement this

1) If you SQL procs are independent on one another and your SQL server are healthy to support 15 executions at a time, then Add one sequence container and add 15 executions tasks (No need to add president constraint)

2) If some of your procs are dependent on one another then three their groups accordingly and then add that many sequence container and then add executions tasks (You need to add president constraint here)

3) If all your procs are dependent then add one sequence container and then add 15 executions tasks with president constraint

Posted 4-Jan-18 0:01am

RDBurmon

Comments

Member 11337367 4-Jan-18 6:08am

Thank for your solution. I have a question on point1 'SQL server are healthy' is this point about processor. Running task is dependent on number of processor being installed on machine?

RDBurmon 4-Jan-18 6:15am

see here , how processor and memory works while query execution
https://msdn.microsoft.com/en-us/library/ff647793.aspx

RDBurmon 4-Jan-18 6:16am

vote and accept if you like the answer

Member 11337367 4-Jan-18 6:21am

Total task=number of processor + 2.is it correct?

RDBurmon 4-Jan-18 6:33am

yes