Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Log table Expand / Collapse
Author
Message
Posted Saturday, December 8, 2012 8:43 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, June 30, 2014 12:49 PM
Points: 320, Visits: 440
I read an article on SSC.com about putting SSIS log messages (specifically, in this case, error messages) into a table so the table could be used to send an email. "Serving Warm SSIS Errors" by Frank Banin 2011/12/09. He tells how to enable SSIS logging for the package, but never tells how to assign a table for the log. He says "Remember to replace sysssislog table in the Stored Procedure with the name of the logging table you used to setup your logging if it was different."

Where is that assigned?
http://www.sqlservercentral.com/articles/HTML/86897


Jim
Post #1394337
Posted Saturday, December 8, 2012 3:15 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 11:17 AM
Points: 1,184, Visits: 1,220
JimS-Indy (12/8/2012)
I read an article on SSC.com about putting SSIS log messages (specifically, in this case, error messages) into a table so the table could be used to send an email. "Serving Warm SSIS Errors" by Frank Banin 2011/12/09. He tells how to enable SSIS logging for the package, but never tells how to assign a table for the log. He says "Remember to replace sysssislog table in the Stored Procedure with the name of the logging table you used to setup your logging if it was different."

Where is that assigned?
http://www.sqlservercentral.com/articles/HTML/86897

When you right click on your package and setup your logging, you select the Provider type (in the first drop down) to log to SSIS log provider for SQL Server (there are other options like Windows Event Log and XML, ...). After selecting SQL Server in the provider type drop down, select (or create) a connection pointing to your table you're using for error logging. The author uses a table names sysssislpg, you can create whatever table you like in your database. See the attached screen capture and the two poorly drawn red arrows.

HTH,
Rob


  Post Attachments 
SSIS logging.PNG (10 views, 63.09 KB)
Post #1394361
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse