JC_Lives
asked on
SSIS Extended Properties/Excel version
Hi guys,
When creating a for each loop container, and a Foreach ado.net Schema Rowset Enumerator (I want to loop through excel sheets and load the data to SQL), when I set up a new connection in the "enumerator configuration" section, I am using the extended property "Excel 8.0" but I'm noticing it doesn't work with xlsx files, only xls - which setting works with xlsx?
Thanks,
Luke
When creating a for each loop container, and a Foreach ado.net Schema Rowset Enumerator (I want to loop through excel sheets and load the data to SQL), when I set up a new connection in the "enumerator configuration" section, I am using the extended property "Excel 8.0" but I'm noticing it doesn't work with xlsx files, only xls - which setting works with xlsx?
Thanks,
Luke
you need to use ACE excel drive for xlsx file.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.