开发者

execute SSIS package

开发者 https://www.devze.com 2022-12-31 07:31 出处:网络
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

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

精彩评论

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