SSIS package error in SQL 2008 ActiveX Script but the sql agent job succeeds

• SQLInspired

  Old Hand

  Points: 300

  More actions

  August 22, 2013 at 11:27 am

  #276399

  Hi,

  I am getting this wierd scenario where SSIS SQL agent job suceeds but it actually isnt. I am getting the below error in the job history, but the job suceeds.

  Code: 0xC00291B1

  Source: Parse XML File ActiveX Script Task

  Description: User script threw an exception: "Error Code: 0

  Error Source= Microsoft OLE DB Provider for SQL Server

  Error Description: Query timeout expired

  Error on Line 282

  ".

  End Error

  DTExec: The package execution returned DTSER_SUCCESS (0).

  Package execution validated as success.

  Please share your thoughts, Thank you for spending your time.