CODEWITHSUNDEEP
sql-serverexcelssisetl
MJ8
MJ8

Reputation: 305

unexpected termination error in ssis

While running ssis package from a server i get the following errors.

Data Flow Task:Error: Excel Source failed the pre-execute phase and returned error code 0xC0202009 Data Flow Task :Error: SSIS Error Code DTS_E_OLEDBERROR . An OLE DB error has occurred.Error code:0x80004005 An OLE DB record is available.Source ."(null)" Hresult 0x80004005 Description:"(null)".

To remedy the issue i have loaded the same data in small numbers and no issue .However,if i have excel file with 25000 rows the ssis package fails.Since i am working with larger data , i need a better solution.

Upvotes: 2

Views: 3028

Answers (1)

Hadi
Hadi

Reputation: 37313

I faced a similar issue, it was solved using this workaround:

First try to import the excel file to sql using SQL server Import and Export Wizard. if it is done successfully. Just choose to save the package to a file system (select this option in the wizard). Open it and edit the package to add other transformation option.

Upvotes: 2

Related Questions