包裹验证错误 [英] Package Validation Error

问题描述

我试图使用一个foreach循环容器将几个excel文件导入到一个表中，我指定了要使用的文件夹和文件(* .xls)，此后我创建了一个路径变量，然后我转到excel源连接，并在表达式"属性中选择了变量.我创建了foreach容器，但是excel源的connectionString仅显示Provider=Microsoft.Jet.OLEDB.4.0;，因此这意味着它没有采用变量值.我该怎么解决?

I'm trying to use a foreach loop container to import several excel files into a table, I specified the folder and the files I'm going to use (*.xls), after that I created a path variable then I went to the excel source connection and in the "Expression" property I selected the variable. I created the foreach container but, the excel source's connectionString only shows Provider=Microsoft.Jet.OLEDB.4.0;, so it means it's not taking the variable value. What can I do to solve that?

注意:我正在使用SQL Server 2012

Note: I'm using SQL Server 2012

其他信息:

Error at Data Flow Task [Excel Source [20]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.

Error at Data Flow Task [SSIS.Pipeline]: Excel Source failed validation and returned error code 0xC020801C.

Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.

Error at Data Flow Task: There were errors during task validation.

Error at Package [Connection manager "Excel Connection Manager"]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E4D.

(Microsoft.DataTransformationServices.VsIntegration)

推荐答案

检查下面我回答的链接主要集中在RUN64BITS TO FALSE而不是TRUE.

Check the link below where I answer mainly focus on RUN64BITS TO FALSE instead of TRUE.

加速源错误

这篇关于包裹验证错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！