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.