将日志写入SSIS中的文件 [英] write Log to a file in SSIS

问题描述

大家好，

我想将日志写入文件.

有一个名为源"的文件夹，文件系统任务将拾取该文件夹中的文件，并将其放入另一个名为目标"的文件夹中.

当文件到达目的地"文件夹时，它必须写入一个日志文件，告知此时文件已到达，并且还必须在日志中指定文件名.

这意味着它应该指定文件名和时间，以及是否可以成功访问它.

请帮我在脚本任务中编写代码.

解决方案

您做了什么吗?您已启动任何脚本吗?我可以看到Internet上有很多讨论该主题的文章.您可以查看以下内容:

http://msdn.microsoft.com/en-us/library/ms138020.aspx [ ^ ]
http://pragmaticworks.com/Products/Business-Intelligence/BIxPress/ssis- logging-auditing-monitoring.aspx [ ^ ]
http://www. coderslife.com/Blogs/mhardy/post/2009/05/26/Basic-SSIS-Logging-to-a-Text-File.aspx [
When the files reached to the "destination" folder it has to write in a log file telling file has reached at this time and it also has to specify the file name in the log.

That means it should specify the file name and time and whether it is reached successfully or not.

Please help me out to write the code in Script Task.

解决方案

Have you done anything yet? Any script you have started? I can see there are lots of articles on the Internet that discuss this topic. You can take a look at the following:

http://msdn.microsoft.com/en-us/library/ms138020.aspx[^]
http://pragmaticworks.com/Products/Business-Intelligence/BIxPress/ssis-logging-auditing-monitoring.aspx[^]
http://www.coderslife.com/Blogs/mhardy/post/2009/05/26/Basic-SSIS-Logging-to-a-Text-File.aspx[^]

这篇关于将日志写入SSIS中的文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！