如何从自定义日志提供程序中关闭包开始和包结束?
在我的 SSIS 包中,我创建了一个自定义日志提供程序,它将所有日志附加到一个 html 文件中。在日志记录详细信息中,我选择仅记录错误和警告。但是,我也收到了开始和结束包日志条目。这违背了仅在错误发生时才能看到错误的目的。有什么建议吗?
我正在运行 SQL 2008 R2。我在网上读到一篇文章,建议在注册表中进行编辑,但这似乎只关闭了 Windows 事件日志中的开始和结束事件的记录,而不是我的记录。
In my SSIS package, I created a custom log provider that appends all my logs into an html file. In the logging details, i selected ONLY errors and warnings to be logged. However, i am getting the Start and End Package log entries as well. This defeats the purpose of being able to see errors only when they happen. Any suggestions?
I am running SQL 2008 R2. I read an article online that suggests to make an edit in the registry, but this seems to have only turned off logging for Start and End events in the Windows event logs, not in mine.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
另一种选择是您可以将错误记录到 SQL Server 数据库,而不是使用自定义日志提供程序。这样您就可以编写简单的查询来根据您想要查看的内容过滤数据。
An alternate option would be that you can log the errors to SQL Server database instead of using custom log provider. That way you can write simple queries to filter the data based on what you would like to view.