Locate SSIS logs when its run from Microsoft Visual Studio

Posted on 2012-09-19
Last Modified: 2012-10-05

When I am running package under debug mode, where would I find the SSIS logs that are not on 'Execution Result' tab. What I really need is to find the previouse debug 'Execution Result'. Main reason is when I debub the previouse Execution Result would not see as its gives me latest execution result.

many thank on this help
Question by:keplan
    LVL 21

    Expert Comment

    by:Alpesh Patel
    for that use SSIS logging  in SQL server table and see the result in SSISlog table.
    LVL 37

    Accepted Solution

    If you're not yet using the SSIS logging features (which you probably aren't or you would have found the log data :), you should really look into that.  There are several methods, with logging to a database table being the more interesting one as it allows filtering ond so on.

    To activate DB logging on a package, do the following:

    First create a new Connection Manager that points to the database that will store the logs

    Then right-click the yellow background in Control Panel and select Logging...

    In the popup window, select "SSIS log provider for SQL Server" as Provider type and click the Add button.  The table below now shows one record.  Take note of the checkbox in front of the Name item, you'll need to check it further down.  In the Configuration column, select your new Connection Manager.

    In the tree structure on the left, check all checkboxes.  Now check the checkbox that I mentioned earlier.

    Switch to the Details tab and check: OnWarning, OnError and OnTaskFailed.  You can select all events if you want but they'll generate way too many records and usually you're only interested in error details anyway, right?

    If you now run your package, your logging database should now contain a table called sysssislog (possibly located under System Tables) with your log details.

    More info:

    Author Closing Comment

    excellent, thanks so much

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…
    With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

    737 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

    18 Experts available now in Live!

    Get 1:1 Help Now