SSIS OLEDB Error

• gramanjul

  SSC Veteran

  Points: 249

  More actions

  December 8, 2011 at 6:01 am

  #247992

  Hi All,

  While executing the SSIS package form job agent some times it's working fine, some times it's failed with below error message.

  An OLE DB error has occurred. Error code: 0x8000FFFF.

  component "OLE DB Source" (1) failed the pre-execute phase and returned error code 0xC0202009.

  I tried different methods but not successes to run the package regular intervals. Can Any one help to resolve this issue

• drew.allen

  SSC Guru

  Points: 77013

  More actions

  December 9, 2011 at 7:08 am

  #1419326

  There should be another error message before this one that will give you details about the exact error that occurred. Without that previous error message, we can't really tell you how to fix the problem.

  Drew

  J. Drew Allen
  Business Intelligence Analyst
  Philadelphia, PA