SSIS History

In SSMS I have a SQL Servre Agent job that executes a package in SSIS. The job ran however my expectations did not come to be. My thoughts are that maybe the SQL Agent Job did indeed run, however perhaps something happened with the SSIS package.
My question is; Is there a way to go into BIDS to the package in question to see if it did indeed run?
It would be analagous to the View History in SQL Agent. Note: I did receive my email alert that the package ran, however the final data produced should have doubled and it remained as it was prior to the package run.
Who is Participating?
This is why I build in run history recording into the packages I create.  I have run into similar issues and, AFAIK, unless you have provided a means for the package to record its progress somewhere, you will not be able to know how much (if any) of the package actually executed other than by the package failing (which then gives you no real clue).

If you got the email saying the package ran, did it indicate success or was it just a "completion" message?  If it was a completion message, I would suggest changing that so that there is a failure and a success notification.

I can also suggest an add-in for BIDS that will help a lot in this area.  It is BI-Xpress.  Note: I am not affiliated in any way with Pragmattic Works, the vendor of BI-Xpress, and neither will I in any way profit from this recommendation.  I have used the tool and I know several others who have used the tool and it can greatly speed up the addition of trace information for your packages.
If you configure LOG Providers you can check in appropriate place.

I Prefer Windows Event Log.
Alpesh PatelAssistant ConsultantCommented:
Please check by run package using BIDS and double check acceptance of data. If it passes your expectation then schedule SQL Job for that.
Alpesh PatelAssistant ConsultantCommented:
Moreover, You can't see the running package using SQL Job in BIDS.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.