[Excel目标[60]]错误：SSIS错误代码DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER。 AcquireConnection方法调用连接管理器“Excel Connection Manager”。失败，错误代码为0xC0202009。 [英] [Excel Destination [60]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009.

问题描述

我为每个循环容器生成一个从SQL数据库获取数据并根据循环中的条件将其输出到不同的Excel文件中。每次运行包时，它会随机生成x个Excel文件，然后在主题中无法获得
错误（无法获取连接管理器），即。有时会生成10个excel文件，有时是20个，有时是30个，但不是全部。 

I have a for each loop container that produces obtains the data from a SQL database and outputs it in different Excel files based on the condition in the loop. Every time I run the package it randomly produces x amount of Excel files then fails with the error in the subject (Cannot Acquire Connection Manager) ie. sometimes it produces 10 excel files, sometimes 20, sometimes 30 but not the full amount. 

我已将RunIn64BitMode属性设置为False并将Delay Validation设置为True。 

I have set the RunIn64BitMode property to False and set Delay Validation to True. 

我的Excel版本是2010年。 

My version of Excel is 2010. 

感谢任何帮助。 

Any help is appreciated. 

shaykh

推荐答案

嗨  Shaykh37，

Hi Shaykh37,

我是否知道如何配置Foreach循环容器？

May I know how do you configure your Foreach Loop Container?

我是否知道如何设计数据流任务并设置excel连接管理器？

May I know how do you design your data flow task and set the excel connection manager?

您能否分享数据流任务中组件的截图和源代码中的数据？

Could you please share the screenshot of the components in your data flow task and the data in your source?

最好的问候，

Mona Lv

 

这篇关于[Excel目标[60]]错误：SSIS错误代码DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER。 AcquireConnection方法调用连接管理器“Excel Connection Manager”。失败，错误代码为0xC0202009。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！