SSIS Package that Fails when run as a Job in MSDB

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  March 27, 2012 at 3:25 pm

  #145050

  I have an SSIS Package that Fails when run as a Job in MSDB.

  It runs fine in BIDS.

  I get message in the Job History that it failed tables.

  When you run a Package stored in MSDB is it slower?

  What it an easy way to identify the first task that failed?

  I would appreciate any feedback.

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  March 28, 2012 at 12:11 am

  #1465468

  What is the error?

  To determine the task that failed you need to use the logging mechanisms in SSIS.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  March 28, 2012 at 7:54 am

  #1465685

  I have logging set to log OnError and OnTask Failed but this is all that the log contains:

  #Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message

  Obviously I'm not doing it right?

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/