Post reply

How to find out if your packages in PROD got modified

  • November 20, 2006 at 8:46 am

    #115363

    We have this incident where the packages in production got changed with the data source pointing to QA instead of PROD.  Are there ways to find out if the packages in production have been changed and then notified DBA of the changes thru email?

    Thanks for helping me.

  • November 21, 2006 at 9:50 am

    #673254

    Each package has a Major.Minor.Build version number. You could keep track of what versions have been deployed where and then if you suspect something has changed, go and check those version numbers.

    The Build number gets incremented every time teh package is saved.

    -Jamie

     

    Jamie Thomson
    http://sqlblog.com/blogs/jamie_thomson

  • November 21, 2006 at 11:35 am

    #673275

    I would suggest perhaps implementing a change control policy also..

  • November 21, 2006 at 11:08 pm

    #673380

    Hi,

    You can Sign the packages. This will ensure that the package you run today is the same package that you deployed yesterday. With digital signing, you can detect whether a package has been changed. You can look for more of Security features in SSIS.

    THanks,

    S Suresh

Viewing 4 posts - 1 through 3 (of 3 total)

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