Solved

SSIS Job - Unexpected Termination - SQL Server 2012

Posted on 2014-10-21
2
396 Views
Last Modified: 2016-02-11
We had an SSIS package Terminate Unexpectedly which was probably due to a unplanned server restart. The issue here is that even though the package history shows that it terminated unexpectedly the SQL Server job did not fail. Why would the SQL Server job not fail in this case and are there any basic configuration settings which can be changed to make sure that any SSIS failure or termination will immediately fail the SQL Sever job.
0
Comment
Question by:VitaminD
2 Comments
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
Comment Utility
Please have a look at details from link below (not sure about your SQL Version/Edition but it should be the same) and note that you should also use SSIS Logging to address any failures or other issues within your SSIS Packages.

http://dba.stackexchange.com/questions/66405/sql-server-2012-agent-job-not-providing-full-failure-message-for-ssis-packages
0
 
LVL 14

Expert Comment

by:nishant joshi
Comment Utility
Hey Sun Ray (Vitamin D) :),

Use below property of SSIS to cause job immediate fail in case of any task or any container fail.

FailPackageonFailure
FailParentonFailure

Make both property to true,this will send error to job.

FailPackageOnFailure.JPG
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

From time to time, for debugging and troubleshooting your flow at run time you’ll need to check if the variable has the correct value or not, there’re several ways to check for the value of the variables inside the flow, You can add Break Points, a …
My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

763 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