SSIS 2008包在64位计算机上的部署错误 [英] SSIS 2008 packages deployment error on 64 bit machine

问题描述

伙计们

我在带有BIDS项目的SSIS 2008中创建了几个程序包.让我说一下，大约2个月前，我在32位计算机上创建了这些程序包，并将其部署在32位Windows Server 2008上.一切正常，并且数据已成功从MS Access数据库导入到SQL Server，没有任何错误或警告.

现在两个月后，这些软件包突然停止工作，并开始发出错误消息，这些消息的用处不大:

Hi Guys

I have created a couple of packages in a SSIS 2008 with BIDS project. Let me mention that I created these packages on a 32-bit machine and deployed them on a 32 bit Windows Server 2008 about 2 months ago. Everything worked fine and the data was successfully imported from MS Access database to SQL server without any error or warning.

Now after 2 months the packages suddenly stopped working and began giving error messages which are not much useful:

[OLE DB Destination [25]] Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E37.
An OLE DB record is available.  Source: "Microsoft OLE DB Provider for SQL Server"  Hresult: 0x80040E37  Description: "Table does not exist.".


[OLE DB Destination [25]] Error: Opening a rowset for " [MyTable1]" failed. Check that the object exists in the database.


[SSIS.Pipeline] Error: "component "OLE DB Destination" (25)" failed validation and returned validation status "VS_ISBROKEN".

我检查了我的目标表是否存在.但是仍然错误消息说它不存在.

我为项目属性强制设置了"Use64bitRuntime = false".

我尝试设置属性"DelayValidation = false"，该属性在技术博客上建议使用，并且适用于许多用户.但这并不能解决我的问题.程序包仍然失败，并出现上述相同的错误.我在线阅读了数十篇博客，但似乎找不到原因.我怀疑罪魁祸首是32位和64位oledb驱动程序之间的差异.

请让我知道是否有人遇到类似的问题，并且他能够以任何方式解决它.

欢迎提供建议，澄清和参考链接...

I checked that my destination table does exists. But still the error message says that it does not exists.

I forcefully set the ''Use64bitRuntime=false'' for the project property.

I tried setting the property ''DelayValidation =false'' which was recommended on tech blogs and worked for a number of users . But it did not resolve my issue. The package still fails with the same error mentioned above. I read through dozens of blogs online, but I couldn''t seem to find the reason. I suspect the culprit is the difference between 32 and 64 bit oledb drivers.

Please let me know if anybody faced a similar problem and was he able to resolve it by any ways.

Suggestions, clarifications and reference links are all welcome...

推荐答案

是的，它是ACE OLEDB驱动程序的64位兼容性.您有两种选择.

1.强制将包执行为32位模式.
2.安装最新的ACE OLEDB驱动程序:
http://www.microsoft.com/en-us/download/details.aspx? id = 13255 [^ ]

如果您正在使用SQL Agent Job运行/计划程序包，则可以选择使用32位模式.
如果单独运行该程序包，则将32位dtexec.exe与/X86 falg一起使用:
http://msdn.microsoft.com/en-us/library/ms162810 (v = sql.100).aspx [

Yes, it''s the 64 bit compatibility of ACE OLEDB drivers. You have two options.

1. Force the package execution to 32 bit mode.
2. Install latest ACE OLEDB drivers:
http://www.microsoft.com/en-us/download/details.aspx?id=13255[^]

If yo are using SQL Agent Job to run/schedule package, ther''s is an option to use 32 bit mode.
If you run the package individually use 32 bit dtexec.exe with /X86 falg:
http://msdn.microsoft.com/en-us/library/ms162810(v=sql.100).aspx[^]

这篇关于SSIS 2008包在64位计算机上的部署错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！