I have a Foreach Loop Container looping through a directory and importing ExcelSource data to SQL Server. The connection is fine until I add the expression to the ExcelSource Connection Property. I followed all the steps in the tutorial. Why do I keep getting the following error?:
我有一个Foreach循环容器，它遍历一个目录，并将ExcelSource数据导入到SQL Server。在将表达式添加到ExcelSource连接属性之前，连接是可以的。我遵循了教程中的所有步骤。为什么我总是得到以下错误?
[Excel Source [2]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager 4" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
[Excel源代码[2]]错误:SSIS错误代码dts_e_cannotacquireconnectionmanager。对连接管理器“Excel connection manager 4”的获取连接方法调用失败，错误代码为0xC0202009。在此之前，可能会出现错误消息，并提供更多关于为什么AcquireConnection方法调用失败的信息。
1 个解决方案
#1
1
You would have to set DelayValidation to true on both Foreach Loop Container and Excel Connection Manager for this to work.
您必须在Foreach循环容器和Excel连接管理器上设置DelayValidation以实现此功能。
#1
1
You would have to set DelayValidation to true on both Foreach Loop Container and Excel Connection Manager for this to work.
您必须在Foreach循环容器和Excel连接管理器上设置DelayValidation以实现此功能。