July 26, 2012 at 9:30 am
Hello All,
I have a unique situation and I am hoping that some one form here can help me out in this matter.
we have a SSIS package set up to run on demand by business when they needed in a test environment.
yesterday, we were contacted buy the developers that SSIS package has been started and its populating a table. Developers say that they have no started the package.
i want to know the execution history/ run history of this particular package like when i look for a database restore history in MSDB database.
is there any way I can find the execution or run history of the package.
Thanks in advance.
July 26, 2012 at 10:03 am
The easiest way would be to run the SSIS package only through a SQL Agent job. You would then have history available through SSMS.
You could also set up the SSIS package to run a stored procedure and then start a profiler trace logging that SP.
July 26, 2012 at 2:43 pm
Mine have logging in them from the very start so I can track every time a package has been fired from dev or prod, agent or not, as a child or independently.
It's nicely automatic.
I don't suppose the pkg operates on a table and leaves a LastUpdate nugget for you?? worth an ask.
July 27, 2012 at 7:53 am
No, it doesn't,, i have looked in to it and reached a conclusion there is no table that can tell you when the ssis was fired ,,, the logging works but in our environment we font have logging enabled for SSIS.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply