InstantForum.NET v4.1.4SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 21 Nov 2009 14:27:54 GMT20http://www.sqlservercentral.com/Forums/Topic747134-146-1.aspxThough this is not my question, thanks Elliott for the answer. This will prove useful in my environment as well.In addition to using TFS already.Fri, 10 Jul 2009 11:42:49 GMTCirquedeSQLeilhttp://www.sqlservercentral.com/Forums/Topic747134-146-1.aspxInternally there are several ways to detect this, one of the best IMNSHO, is VersionBuild in the package properties, it is updated everytime the package is saved (if there were any changes) and the user doesn't have to do anything. The other properties, CreateDate, MajorVersion, MinorVersion are changed by the user, there is no auto chage going on there. The only other field that is auto changed is VersionGUID, but all that would really tell you is that it is different than another saved version, not how man versions there are between. As part of my auditing process I capture all of this and write it to an audit database at the start of package execution. That way I have an indisputable way to state that a package did change and that the runs of that package before that date used a particular version and the runs after used a different version. It helped a lot with the BI work I was doing to know what package version was in play so we knew if a problem had been persisted into newer versions..CEWIIFri, 10 Jul 2009 10:57:09 GMTElliott Whttp://www.sqlservercentral.com/Forums/Topic747134-146-1.aspxThis script returns createdate column. Does this data tell us the date the package is updated?Fri, 10 Jul 2009 10:22:20 GMTSQL ORACLEhttp://www.sqlservercentral.com/Forums/Topic747134-146-1.aspxSELECT * FROM [msdb].[dbo].[sysdtspackages90]HTH!MJTue, 07 Jul 2009 20:42:48 GMTMANU-296622http://www.sqlservercentral.com/Forums/Topic747134-146-1.aspxIt is saved in msdb. What I would like to know is how to retrieve the date the packages were modified.Mon, 06 Jul 2009 07:53:19 GMTSQL ORACLEhttp://www.sqlservercentral.com/Forums/Topic747134-146-1.aspxdo you keep the SSIS packages on the file system or in MSDB? if you keep them on the file system then the modified date of the package will change with each new release. you would normally keep SSIS packages in sourceSafe or a similar if you have multiple devs working on the same packages, then you can use the inbuilt version tracking in those tools.if they are stored in MSDB im sure you must be able to query one of the system tables, im not sure which ones they use without looking but im sure there will be a modified date on one of them that you could query or stick a trigger on to mail you.Sat, 04 Jul 2009 05:44:35 GMTAnimal Magichttp://www.sqlservercentral.com/Forums/Topic747134-146-1.aspxMany thanks in advance.Fri, 03 Jul 2009 18:37:30 GMTSQL ORACLE