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
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
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.
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?



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.
5 people are following this question.
SSIS Scale Out and its services on local group policies
Where do I download SSDT July 2016 Update (ver. 14.0.60629.0) from?
we hope Microsoft can develop databases like mysql
integration services ne figure pas dans la liste des fonctionnalités partagées de sql server
SSIS - getting data from Oracle - not working preview and metadata refresh