Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Log error details in SSIS when executed by an SQL Agent job

Posted on 2012-03-11
2
537 Views
Last Modified: 2012-03-12
If an SSIS package is executed by a SQL Agent job, is there a way to log the error details of the package if the package fails.

By error details I meant something like the information displayed in the Output window when a package is run on BIDS.

Thanks.
0
Comment
Question by:thomaszhwang
2 Comments
 
LVL 17

Accepted Solution

by:
Barry Cunney earned 500 total points
ID: 37709855
When designing the SSIS package in BIDS you can configure error logging:
http://msdn.microsoft.com/en-us/library/ms167456.aspx
0
 

Author Closing Comment

by:thomaszhwang
ID: 37711205
Thanks.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

840 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