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

Package Versioning in MSDB Expand / Collapse
Author
Message
Posted Wednesday, November 7, 2007 6:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 9, 2010 11:41 AM
Points: 1, Visits: 9
At my company, we deploy our SSIS packages to the MSDB.

Recently, for an audit, we were asked to provide an automated list of changes to some of the primary packages. In DTS 2000 this would be easy using the system tables like sysdtspackages. Is there something in SQL 2005 to create this same kind of audit trail?

TIA.
Post #419586
Posted Wednesday, November 7, 2007 1:26 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, August 21, 2014 8:03 AM
Points: 621, Visits: 348
for 2005, the table that replaced the packages table is sysdtspackages90. In there, you will see you list of packages with the created date and package version.

Post #419752
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse