SQLTeam.com | Weblogs | Forums

Enumerator Foreach ADO.NET Schema Rowset Enumerator Missing Excel Data load into SQL Table

Experts,

Problem: Microsoft Office 12.0 Access Database Engine OLE DB Provider does not appear in list of Data Sources in SQL Server Integration Services Wizard under ForEach Loop Container


Trying to load data from multiple excel sheets into SQL Table and using the Enumerator Foreach ADO.NET Schema Rowset Enumerator Missing on Foreach Loop Container while configuring the Package.
Myself have checked whether 64-bit is causing not to show in the box, then ProjectName --> Properties -->Configuration --> Debugging --> Debugging Options --> RunBitRuntime --> False.

Also checked with Access Database Engine OLE DB Provider for which downloaded and executed on the VmWare Server Instance where the SSIS is installed.
Restarted the Server Instances many times and try to open in ForEach Loop Container where selecting the ADO.NET Schema Rowset Enumerator, but Microsoft Office 12.0 Access Database Engine OLE DB Provider does not appear in list of Data Sources.

Could you please advise.