SSIS Excel 连接错误“外部表不是预期的格式." [英] SSIS Excel connection error "External table is not in the expected format."

问题描述

问题

-我有一个 Excel 电子表格生成了一个 Lotus 应用程序.它闻起来像 excel，但 Excel Source 数据流源无法识别它.尝试选择表(选项卡)时，我收到以下错误消息外部表不是预期的格式."

-I have an excel spreadsheet generated a lotus app. It smells and looks like excel but Excel Source data flow source can not recognise it. When trying to select a table(tab) i get the following error message "External table is not in the expected format."

-打开 Excel 电子表格并再次保存它会有所帮助(文件也减小了大小).但作为开发人员，我们反对手动流程.

-Opening the excel spreadsheet and save it again helps(File also reduces in size). But as dev we ara allegic to manual processes.

-我尝试使用变量更改连接字符串

-I have tried to change the connection string using a variable

来自

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\DataImport\Lotus.xls;Extended Properties="Excel 8.0;HDR=YES";

到

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\DataImport\Lotus.xls;Extended Properties="EXCEL 12.0;HDR=YES";

如果我能避免脚本任务就好了

If i can avoid the script task that would be great

推荐答案

我不得不手动打开和关闭 excel 文件保存.那些无法修复的错误

I have had to open and close the excel file manually saving. Those bugs that can't be fixed

这篇关于SSIS Excel 连接错误“外部表不是预期的格式."的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！