Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 920
  • Last Modified:

SSIS Job - Unexpected Termination - SQL Server 2012

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
VitaminD
Asked:
VitaminD
1 Solution
 
lcohanDatabase AnalystCommented:
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
 
nishant joshiTechnology Development ConsultantCommented:
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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

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