Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Store ISPAC filename + analyse timestamp #25

Closed
fpatou opened this issue Sep 4, 2018 · 2 comments
Closed

Store ISPAC filename + analyse timestamp #25

fpatou opened this issue Sep 4, 2018 · 2 comments
Assignees

Comments

@fpatou
Copy link

fpatou commented Sep 4, 2018

hello

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

Regards

@keif888 keif888 self-assigned this Sep 7, 2018
@keif888 keif888 added the bug label Sep 7, 2018
@keif888
Copy link
Owner

keif888 commented Sep 7, 2018

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.

@keif888 keif888 added the fixed label Sep 7, 2018
@fpatou
Copy link
Author

fpatou commented Sep 7, 2018

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

@keif888 keif888 closed this as completed Apr 8, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants