SSIS fails Irregularly

• srinivas_reddy48

  SSC Enthusiast

  Points: 197

  More actions

  March 25, 2009 at 4:35 am

  #129988

  I have 2 jobs running through Management Studio. One job runs at 5.30 in the morning and the other at 7.00 in the morning. Both the jobs use the same ETL packages. The only thing that differs is the variables they use.

  I have been getting the errors like

  1.An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "Deferred prepare could not be completed.".

  An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The incoming tabular data stream (TDS) protocol stream is incorrect. The stream ended unexpectedly.".

  2. OLE DB error occurred while loading column metadata. Check SQLCommand and SqlCommandParam properties.

  3. "Lookup Table" (79) failed the pre-execute phase and returned error code 0x80004005.

  The job contains 4 packages running one after the other. Till recently the second job(7.00 am ) was failing with the above errors after I have upgraded with SP3 the first job is failing now and second is working fine.

  Any ideas in this would be of great help.

  Thanks,

  Sri

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  March 25, 2009 at 9:40 am

  #966058

  This is double post. The same question is posted here.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/