Integration Services – Error – “SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E37”

 

Error

Error Image

Error Text

Started:  6:15:02 AM
Error: 2018-01-18 06:15:07.61
Code: 0xC0202009
Source: Read Excel Data Excel Source File [49]
Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E37.
End Error
Error: 2018-01-18 06:15:07.61
Code: 0xC02020E8
Source: Read Excel Data Excel Source File [49]
Description: Opening a rowset for "Sheet1$" failed. Check that the object exists in the database.
End Error
Error: 2018-01-18 06:15:07.65
Code: 0xC004706B
Source: Read Excel Data SSIS.Pipeline
Description: "Excel Source File" failed validation and returned validation status "VS_ISBROKEN".
End Error
Error: 2018-01-18 06:15:07.65
Code: 0xC004700C
Source: Read Excel Data SSIS.Pipeline
Description: One or more component failed validation.
End Error
Error: 2018-01-18 06:15:07.65
Code: 0xC0024107
Source: Read Excel Data
Description: There were errors during task validation.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started:  6:15:02 AM
Finished: 6:15:08 AM
Elapsed:  6.422 seconds

 

TroubleShooting

SQL Server Agent

Job Step

Image

Tabulate

Item Value Breakdown
Connection String Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\Import\Sample.xlsx;Extended Properties=”EXCEL 12.0 XML;HDR=YES”;
Provider = Microsoft.ACE.OLEDB.12.0
Extended Properties=”EXCEL 12.0 XML;HDR=YES”
Extended Properties=”EXCEL 12.0 XML;HDR=YES”

 

Remediation

Microsoft Access Database Engine 2010 Redistributable

Guidance

Link

Step

Download and apply “Microsoft Access Database Engine 2010 Redistributable“.  It is available here.

We are on a 64-bit machine and so we downloaded the 64-bit version.

Restart the machine or just the related services ( SQL Server Engine, SQL Server Agent and Integration Services ).

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s