Executing one task

Question

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

Answer 1

Hi @Vaishu ,

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.

Answer 2

Hi @Vaishu ,

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?

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.