开发者

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
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜