SSIS package failed for JOB.

• asheesh pandey

  Old Hand

  Points: 359

  More actions

  March 6, 2012 at 12:35 pm

  #252712

  Hi,

  We have working on SSIS with maintenance plan migration through SSIS but getting error.

  SSIS package "Package.dtsx" starting.

  Error: 0xC002F325 at Transfer Jobs Task, Transfer Jobs Task: Execution failed with the following error: "An exception occurred while transferring job "Index Rebuild.Subplan_1".".

  Error: 0xC002F325 at Transfer Jobs Task, Transfer Jobs Task: Execution failed with the following error: "An exception occurred while executing a Transact-SQL statement or batch.".

  Error: 0xC002F325 at Transfer Jobs Task, Transfer Jobs Task: Execution failed with the following error: "Cannot insert the value NULL into column 'owner_sid', table 'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.

  The statement has been terminated.".

  Task failed: Transfer Jobs Task

  Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

  SSIS package "Package.dtsx" finished: Failure.

  So please any one...greatly appreciated.

  Note:We are able to transfer login and other jobs through SSIS but only failed for maintenance plan migration.

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  March 6, 2012 at 11:40 pm

  #1455749

  Do you have a job that has no owner?

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