SSIS PROJECT ERROR ON BUILD

  • I have SSIS project for the purpose to fetch data from excel sheet and first insert data into database and then show their status in text file on same path or same folder.

    2 month ago the SSIS package was working properly. but right now i just change the file path and then rebuild the porject.

    After rebuilding the project its show the following error.

    Any one can hehlp me why my project show the following error.

    or how can i solve the following error.

    Error2Validation error. LCMS Resultat fil Connection manager "Excel Connection Results": SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft Access Database Engine" Hresult: 0x80004005 Description: "Could not find installable ISAM.".

    LCMS Resultat fil.dtsx00

    Error3Validation error. Genere resultat fil Excel Source 1 [1939]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Results" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

    LCMS Resultat fil.dtsx00

  • OK, that sounds annoying, but what's your question, exactly?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply