Home > SQL Server > Logging feature in SSIS 2008

Logging feature in SSIS 2008


The built in logging in SSIS is fantastic. However , some of you might have tried to implement this in SSIS 2008 only to find that it doesn’t work. Well there are a couple of things I can tell you. The first is that when you use SQL Server logging and point it to a database, it will create the table as a System Table not a normal one. So go to your database and expand – Tables – System Tables and you should see it there. The second is that the table name has now changed to a more relevant ssislog instead of dtslog90.
Advertisements
Categories: SQL Server
  1. siva
    July 20, 2009 at 7:00 am

    I am gonna forward this blog to my database guys and I am sure they might find it very useful. Thanks

  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: