Joe the Business Intelligence Guy

A journey through the design and delivery of business intelligence solutions.

SSIS 2008 Logging and Package Configuration Objects FAQ

SSIS 2008 Logging to SQL Server

1. Can I change the dbo.sp_ssis_addlogentry system stored procedure to non-system stored procedure and if so how is this done?
 Yes – you must drop and recreate the procedure (and don’t run [sp_MS_marksystemobject] N'[dbo].[sp_ssis_addlogentry]’)

2. Can I change the dbo.sysssislog system table to non-system table and if so how is this done?
 Yes – you must drop and recreate the table (and don’t run execute [sp_MS_marksystemobject] N'[sysssislog]’)
 
3. Is the new SSIS 2008 logging stored procedure dbo.sp_ssis_addlogentry different than the SSIS 2005 logging table dbo.sp_dts_addlogentry?
 No

4. Is the new SSIS 2008 logging table dbo.sysssislog different than the SSIS 2005 logging table dbo.sysdtslog90?
 No, the schema is the same

5. Can I change the dbo.sp_ssis_addlogentry procedure to reference a different named table other than dbo.sysssislog?
 Yes – you must drop and recreate the procedure changing the referenced table name found after INSERT INTO
  I often name this table as Audit.ETLAuditSSISLog

6. Can I change the name of the dbo.sysdtslog90 table?
 Yes – you must drop and recreate the table
  Additionally, you must drop and recreate the SSIS 2008 logging stored procedure dbo.sp_ssis_addlogentry
  in order to change the referenced table name found after INSERT INTO
  I often name this table as Audit.ETLAuditSSISLog

7. Can I change the name of the dbo.sp_ssis_addlogentry procedure?
 No – SSIS will simply recreate the procedure if it is missing while the solution/package is configured to used SQL server logging.

SSIS 2008 Package Configuration using SQL Server

1. Is the new SSIS 2008 package configuration table different than the previous SSIS 2005 package configuration table?
 No – the schema is identical

2. Can I change the name of the package configuration table?
 Yes – you just have to change the SSIS reference in the Package Configuration Wizard (Configuration table)

Advertisements

Written by Joe Salvatore

March 11, 2009 at 1:51 am

%d bloggers like this: