开发者

is it possible to log events of ssis package execution using c# to a file

开发者 https://www.devze.com 2023-01-07 16:02 出处:网络
Is it possible to log the events of ssis package execution called from c# Application ap开发者_如何转开发p = new Application();

Is it possible to log the events of ssis package execution called from c#

 Application ap开发者_如何转开发p = new Application();
 Package package = app.LoadPackage("<package_path>", null);
 package.ImportConfigurationFile("<configuration_path>");
 DTSExecResult result = package.Execute();

I need to log the messages generated during the package execution. I am using SQL Server 2008.

Thanks in advance


the Execute method has an overload for "Log"

log Type: Microsoft.SqlServer.Dts.Runtime.IDTSLogging An IDTSLogging interface.

http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.dtscontainer.execute.aspx

0

精彩评论

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