• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 482
  • Last Modified:

Locate SSIS logs when its run from Microsoft Visual Studio

Hi,

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
0
keplan
Asked:
keplan
1 Solution
 
Alpesh PatelAssistant ConsultantCommented:
for that use SSIS logging  in SQL server table and see the result in SSISlog table.
0
 
ValentinoVBI ConsultantCommented:
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:
http://msdn.microsoft.com/en-us/library/ms138020(v=sql.105).aspx
http://msdn.microsoft.com/en-us/library/ms141212(v=sql.105).aspx
http://technet.microsoft.com/en-us/library/ms186984(v=sql.105).aspx
0
 
keplanAuthor Commented:
excellent, thanks so much
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now