search

keif888 / SQLServerMetadata

SQL Server Metadata Toolkit
Microsoft Public License
83 stars 32 forks source link

Store ISPAC filename + analyse timestamp #25

Closed fpatou closed 2 years ago

fpatou commented 6 years ago

hello

Would it be possible to store those information into the SSIS_META database ? ISPAC filename + analyse timestamp.

Regards

keif888 commented 6 years ago

The ObjectAttrName field with the value PackageLocation, is supposed to be logging the ISPack name. I have corrected that in the commit listed above. You will now get the ISPack name, followed by an back slash, and then the package name within the ISPack (as the dtproj files are already handled). Joining to the RunScan table using the RunKey column will allow the retrieval of the analysis timestamp.

fpatou commented 6 years ago

Thank you this will help a lot ! tested just right now and works sucessfuly