Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Feedback

How to Enable SSIS Logging in the Jet Data Manager


Overview

In the Jet Data Manager it is possible to enable SSIS logging in order to see detailed information that is recorded during the deployment and execution of SSIS packages. This data is then stored in the project repository for easy access.

Process

In order for SSIS logging data to be captured SSIS Logging must first be enabled in the project. To do this, right click the project name at the top of the Data tab and select Edit Project:


On the next screen check the box for "Enable SSIS Logging":


Warning: SSIS Logging can generate a tremendous amount of data that is stored in the project repository database. Always be sure to disable SSIS logging after you are finished using it.
The next time that SSIS packages are deploy or executed details about the event will be written to a table in the project repository database. The table name will depend on the version of SQL being used and will be contained in the following:

SQL 2005: "sysdtslog90" table

SQL 2008 and newer: "sysssislog" (System Table)

This table will contain data about the SSIS packages being deployed and/or executed, the operator that started the action, the computer, the event, the start and end times and a detailed message. These details can all be queried directly from the project repository table.



Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments