Important Fact: Default Logging in SSIS which store log entries in SQL Server
Few days back I have posted an article on “Default Logging in SSIS“. You can refer that here. In that article I have forgotten to mention a behavior of “enabling a default logging in SSIS package“. Let me show you what you need to know about this fact.
Fact: When you enable a “Default Logging” with SQL Server in SSIS package, it does not create any table (i.e. dbo.sysssislog) or stored proc (i.e. dbo.sp_ssis_addlogentry) at the same time of setting-up in SSIS package. But when you run your package first time, these objects gets created automatically.
I hope this tiny information will help you somewhere when you need to build these logging objects programmatically or may be in some other planning related to logging in SSIS
April 27, 2012
Â· Khilitchandra Prajapati Â· No Comments
Tags: Business Intelligence, Default Logging, Quick Tips, SQL Server, SSIS, Tutorial Â· Posted in: Business Intelligence, Default Logging, Quick Tips, SQL Server, SQL Server 2012, SSIS, Tutorial