Thursday, June 27, 2013

SSIS: Sysssislog

What is sysssislog?


It’s a table created in database. This table is automatically created, when we enable logging for SSIS package (SSIS log provider for SQL Server), and after execution of package first time.  For this we need to configure one database connection to a database in which this table will be created.

This table contains one row for each logging entry generated by SSIS package or their tasks during runtime. Each row entry depends contains event for which we have enabled logging such as OnPostValidate, PackageStart, OnPreExecute, OnPostExecute, PackageEnd etc.

By default, each row contain below columns. We can add more column as per our requirement.
id
event
computer
operator
source
sourceid
executionid
starttime
endtime
datacode
databytes
message
1
OnPostValidate

ragini.gupta
Package9


2013-06-13 14:20:10.000
2013-06-13 14:20:10.000
0
0x


How it is created?

Integration Services writes logging entries in this table only when packages use the SQL Server log provider.


Sysssislog table is not created just by executing the task, but we need to execute the package first time to create the table.

Please provide your feedback for the post, if you find this post useful. Also Post your query or scenario, i will be happy to help.

2 comments:

  1. I recently wrote a query which pulls some good information from the syssislog.
    http://troywitthoeft.com/simple-ssis-package-monitoring-for-sql-server-2008/
    Take a look and let me know if the query works for you!

    ReplyDelete
  2. Is there a way to write the logs into a different table, rather than to dbo.sysssislog
    I want to do this differently for each package

    ReplyDelete