Home > Logging, Logging, SQL Server, SSIS, SSIS 2008 > Logging using SQL provider in SSIS 2008 and SSIS 2005

Logging using SQL provider in SSIS 2008 and SSIS 2005

I am starting this post with an assumption that you know to configure logging in SSIS 2005/2008 for SQL Server provider.

There are few differences in the way the information is logged into the table when using SSIS 2008 compared to SSIS 2005.

In 2005 the events are logged into the table by name “sysdtslog90” and in 2008 the events are logged into “sysssislog. By default in 2005 the table is created under the user tables folder, however in 2008 it is created under system tables. You can how ever create a table before the execution of packages  in user tables folder , this will restrict the table from getting created under system tables folder.

A stored proc is created along with the table. In ssis 2005 it is named as “sp_dts_addlogentry” . In 2008 it is named as sp_ssis_addlogentry” and is created under “system SPs ” by default.

You can add additional columns to the tables used for logging and update the values in these columns. This is usually done to customize the logging.

Advertisements
  1. February 5, 2013 at 11:09 am

    Thanks for this clarification – very helpful

  2. August 22, 2014 at 12:56 am

    Howdy very cool website!! Man .. Beautiful .. Amazing ..
    I will bookmark your web site and take the feeds additionally?
    I am satisfied to search out numerous helpful information right here within the publish, we’d like work out extra techniques in this regard, thank you for sharing.
    . . . . .

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: