SSIS - Upgrade from 2005 to 2008 - How to set a project property when I don't have a project
- by Greg
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 MICROSOFT.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?