locked
sql 2014 job history not showing details from ssis failure RRS feed

  • Question

  • We are migrating our ETL servers over to sql 2014 (12.0.2000). all the jobs that fail are not giving any useful failure information. most specifically when we call an ssis package and that step fails the job history simply states "The package Execution Failed: The Step Failed" Its not kicking back the failure message from the ssis package. I'm not concerned with why the jobs are failing I'm just trying to figure out why its not logging the failure detail.
    Thursday, September 3, 2015 5:52 PM

All replies

  • 1)you can create table where you can dump ssis packages details refer following link

    https://www.mssqltips.com/sqlservertip/2149/capturing-and-logging-data-load-errors-for-an-ssis-package/

    2)Using Data Viewer in Data Flow Task:

    This is one of the most commonly used techniques for debugging. As SSIS is an ETL tool and we are mostly dealing with data, in case we need to see what kind of data is passing between 2 Data Flow Tasks we can use this method.



    Please click "Mark As Answer" if my post helped.

    Friday, September 4, 2015 1:27 AM