DTS Import/Export Wizard - strange error message

• mbp2112

  SSC Veteran

  Points: 244

  More actions

  December 4, 2008 at 11:29 am

  #194718

  Howyadoin,

  I'm in the final stages of my migration project, and I'm using the DTS Import/Export wizard to transfer data from my Access DB to my Express db. Most of my table transfers work fine, but one of them (the most important one, naturally) blows up with an error message. What's strange is that it finished the transfer portion of the move and died afterward, without actually copying the records. Has anyone seen this one before?

  Information 0x402090df: Data Flow Task: The final commit for the data insertion has started.

  (SQL Server Import and Export Wizard)

  Error 0xc0202009: Data Flow Task: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

  An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Internal Query Processor Error: The query processor could not obtain access to a required interface.".

  (SQL Server Import and Export Wizard)

  Information 0x402090e0: Data Flow Task: The final commit for the data insertion has ended.

  (SQL Server Import and Export Wizard)

  Thanks,

  -Mark