SSIS - Upgrade from 2005 to 2008 - How to set a project property when I don't have a project
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.
精彩评论