Post reply

Package Versioning in MSDB

  • November 7, 2007 at 6:57 am

    #119371

    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.

  • November 7, 2007 at 1:26 pm

    #749209

    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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply