开发者

SSIS - Upgrade from 2005 to 2008 - How to set a project property when I don't have a project

开发者 https://www.devze.com 2022-12-31 16:27 出处:网络
I have about 160 SSIS packages that I\'m trying to upgrade from 2005 to 2008. When I run SSISUpgrade.exe on them, I get the following error messages on many of the packages:

I have about 160 SSIS packages that I'm trying to upgrade from 2005 to 2008.

When I run SSISUpgrade.exe on them, I get the following error messages on many of the packages:

Error 0xc0209303: ...: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR.  The requested OLE DB provider MICROSOF开发者_开发百科T.JET.OLEDB.4.0 is not registered -- perhaps no 64-bit provider is available.  
enter code here`Error code: 0x00000000.
    An OLE DB record is available.  Source: "Microsoft OLE DB Service Components"  Hresult: 0x80040154  Description: "Class not registered".

This fellow says that to fix this I need to set the run64bitruntime debugging property to False.

However each of these packages exists outside of a project file. How can I set this property without having a project file?


Ok, if I turned off the check box to validate when running SSISUpgrade.exe it seemed to convert everything ok.

Then I just have to call the packages using the 32 bit dtexec found in C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn

I guess that's good enough for me.

0

精彩评论

暂无评论...
验证码 换一张
取 消