execute SSIS package
Is it possible to execute a SSIS package in C# Code ? We can process cube using the namespace "Microsoft.A开发者_如何学JAVAnalysisServices.AdomdClient". What will be namespace/method to be used for executing a package/task, if possible? This considers Script Task too, in SSIS.
see Running a Package Programmatically on the Local Computer from msdn
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
精彩评论