Solved

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

Posted on 2012-03-11
2
539 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
[X]
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
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql update 2 36
how to make geography query faster?  SQL 7 44
sql query 5 43
Cannot connect to SQL express 2008 R2 installed on Server 2016 5 16
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

762 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