Vivien Xing (1/28/2011)
Marios Philippopoulos (1/27/2011)
Vivien Xing (5/7/2008)
I sent a feedback to Microsoft. Package version feature will be considered for the next major release. If you have any comments to add on, here is the link:SSIS Package Version Change Tracking Log in SSMS - SQL2005 & SQL2008
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=341995
Thank you for suggesting this to Microsoft.
Adding the ability of tracking last modified date in packages through querying msdb.dbo.sysssispackages will also help in maintaining a Disaster/Recovery environment with the latest changes in production.
Good point thinking about DR. I am glad that Microsoft heard our voice. It took a couple of years to see the change.
Anyone has tried SQL Server Denali CTP yet? Hope the version tracking feature meets our expectations.
Unfortunately, for the time being I'm stuck with SQL 2008, so I have to make do with the verbuild column of msdb.dbo.sysssispackages.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]