Using SQL Server 2005 (and 2008)
With a DTS package, I can open it, and it lists the date that the package was last modified. I have some SSIS packages, and I need to know if they have been modified since our last release. Is there any way to tell when they were last modified?
If I right-click, the only option that even looks promising is "Reports", but the only option there is a general report that has the package creation date and some versioning information. I already know that the programmer didn't change any of the version defaults, so there is no useful information there.
I want the last modified date, or last imported date, or something to let me know if I need to worry about some of these being modified since our last release.
Edit: The file is stored in MSDB.