SSIS History

Posted on 2011-04-22
Last Modified: 2013-11-10
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.
Question by:SeTech
    LVL 9

    Expert Comment

    If you configure LOG Providers you can check in appropriate place.

    I Prefer Windows Event Log.
    LVL 22

    Accepted Solution

    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.
    LVL 21

    Expert Comment

    by:Alpesh Patel
    Please check by run package using BIDS and double check acceptance of data. If it passes your expectation then schedule SQL Job for that.
    LVL 21

    Expert Comment

    by:Alpesh Patel
    Moreover, You can't see the running package using SQL Job in BIDS.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now