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.