Is it possible to execute a SSIS package in C# Code ? We can process cube using the namespace "Microsoft.AnalysisServices.AdomdClient". What will be namespace/method to be used for executing a package/task, if possible? This considers Script Task too, in SSIS.
+2
A:
see Running a Package Programmatically on the Local Computer from msdn
moi_meme
2010-05-25 12:39:39
Thanks. It worked for me.
Sreejesh Kumar
2010-05-26 07:01:56
How do we perform the execution of a particular control flow task in C# ? Is it possible to change the SSIS variable in C# code just like we perform in Script Task, using the instance of Application class ?
Sreejesh Kumar
2010-05-26 12:28:56
A:
The way we do this is we call a stored procedure from code and this stored procedure runs the SSIS package.
DECLARE @Command varchar(500);
SET @Command = 'dtexec /FILE "<SSIS File Name Goes Here>" /Decrypt "<Password Here>"';
EXEC msdb..xp_cmdshell @Command
joshlrogers
2010-05-25 12:49:03