question

Vaishu-2062 avatar image
0 Votes"
Vaishu-2062 asked Monalv-msft edited

Executing one task

Is there a way to Execute on particular task in SSIS from t sql or c# or any other method, my ssis got about 15 task mostly Execute SQL, On demand, i want to call ssis and execute one task instead of entire ssis

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

YitzhakKhabinsky-0887 avatar image
1 Vote"
YitzhakKhabinsky-0887 answered YitzhakKhabinsky-0887 edited

Hi @Vaishu-2062,

A minimal execution unit at run-time is a package.

You can achieve what you need by redesigning your SSIS package:

  • It is possible to disable any Container/Task at run-time dynamically via project/package boolean parameters set as True or False. You can set the conditions directly/programmatically on the Disable property on any SSIS task in the Control Flow by using Expressions.

  • By using precedence constraints.

  • Rearrange your single monolithic package with mutiple SSIS tasks as one task per package.

The first bullet is the easiest method.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft edited

Hi @Vaishu-2062 ,

We can enable just one task and disable other tasks in ssis packages.
So, we just execute one task when we are running ssis package with many different methods.

Please refer to the following links and pictures:
1.Run an SSIS package with C# code in a .NET app
2.Run an SSIS package from SSMS with Transact-SQL
3.SSIS: How to disable task?

83102-enable.png
83045-disable.png
83046-cf.png

Best regards,
Mona


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.




enable.png (20.8 KiB)
disable.png (28.0 KiB)
cf.png (15.2 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Vaishu-2062 ,

May I know if you have anything to update?

Best regards,
Mona

0 Votes 0 ·