SSIS错误代码DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER - 如何解决 [英] SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER -- How to resolve

问题描述

美好的一天， 

Good Day, 

我在阅读Excel时遇到SSIS包问题。 在这个包中，我阅读了五（5）个Excel数据电子表格，并将数据移动到SQL Server中，然后移到Oracle上。 这个套餐已经工作了（99％）三年。 偶尔，我发现
数据发起人会在这里或那里更改字段名称，我必须重新评估并更正包裹，然后我继续前进。 当前错误：错误代码DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER未解析五个
（5）Excel实例中的一（1）个（每个实例都是一个单独的文件，并且有一个单独的连接管理器）。 我仔细审查了所有这些，但它们看起来都有相同的设置;虽然我确实找到了我必须解决的列命名问题。

I have an issue with an SSIS package reading excel.  In this package I read five (5) Excel spreadsheets for data and move the data into SQL Server and over to Oracle.  This package has been working (99%) for three years.  Occasionally, I find that the data originator will change a field name here or there and I have to reevaluate and correct the package and I move on.  The current error: Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER is not resolving for one (1) of the five (5) Excel instances (each is a separate file and has a separate connection manager).  I have reviewed them all with careful scrutiny and they all appear to have identical settings; although I did find a column naming issue that I had to resolve.

我该怎么做才能清除此错误并继续前进。  

What can I do to clear this error and move on.  

MT

推荐答案

嗨MT2，

每当我看到人们对Excel使用SSIS时，我都会感到难过。

Each time I see people using SSIS against Excel it makes me sad.

在您的情况下，看起来您需要重新部署包裹成功地能够从修改后的另一次Excel中提取数据。

In your case, it looks like you need to re-deploy the package once you can successfully able to extract the data from the modified yet another time Excel.

这篇关于SSIS错误代码DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER - 如何解决的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！