none
Loading Multiple excel files using SSIS for each loop container

    Question

  • Hi ,

    I'm working to load the multiple excel files data into oledb destination.While at the time of changing the connection dynamically I'm getting error as

    TITLE: Microsoft Visual Studio
    ------------------------------

    Error at Package5 [Connection manager "Excel File"]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E4D.

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

     

    ------------------------------
    ADDITIONAL INFORMATION:

    Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap)

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

     

    Wednesday, January 04, 2012 8:53 AM

All replies