April 2, 2014 at 5:16 pm
I am using Excel 2010 file (.xlsx) 64-bit and want to enumerate through different sheets in it. So, I have created a connection manager as shown here: http://imgur.com/2wuJI2W
But when I try to test connection, i am getting an error 'Test connection failed because of an error in initializing provider. Could not find installable ISAM'
Server is 64bit, BIDS is 64bit, Excel is 64bit
I tried with Run64BitRuntime=False and with un64BitRuntime=True..both didnt help.
Can anyone please help me here..
Thanks a lot in advance!!
April 2, 2014 at 5:34 pm
After installing 'AccessDatabaseEngine.exe' from
http://www.microsoft.com/en-us/download/details.aspx?id=13255
I am able to see the columns of the excel file using excel connection manager..but while running the package..I am getting an error
'Error: The GetEnumerator method of the ForEach Enumerator has failed with error 0x80004005 "Unspecified error". This occurs when the ForEach Enumerator cannot enumerate.'
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply