Home Forums Data Warehousing Integration Services SSIS error when configuring data flow task with .xls file RE: SSIS error when configuring data flow task with .xls file
Eric M Russell
SSC Guru
Points: 125523
More actions
December 24, 2015 at 7:03 am
#1847916
Since it's .XLSX, make sure the connection is using the provider that supports Excel 2007+ instead of the provider for the older .XLS format.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho