Home Forums Data Warehousing Integration Services SSIS error when configuring data flow task with .xls file RE: SSIS error when configuring data flow task with .xls file

  • July 8, 2013 at 2:48 pm

    #1630593

    I attempted to write a simple select statement directly in query editor and received the follow error:

    TITLE: Microsoft Visual Studio

    ------------------------------

    Exception from HRESULT: 0xC020801C

    Error at Package [Connection manager "Excel Connection Manager"]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

    An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "External table is not in the expected format.".

    Error at Data Flow Task [Excel Source [69]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

    ------------------------------

    BUTTONS:

    OK

    ------------------------------