fiogf49gjkf0d Douglas:
The provider is installed, but you can only use it from a 32 bit process.
For example, if you were to write your own application using .Net, and compile it to x86, it would work well, whereas if you compile it for x64 it would not work as a 32 Bit OLEDB Provider is not accessible under this space.
In other words, the provider is installed on your machine, but you won't be able to use it from a program running on 64 bit.
If you want to test it using a UDL file, you can do so, but only if you open that UDL file on 32 bit:
C:\Windows\syswow64\rundll32.exe "C:\Program Files (x86)\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile C:\test.udl
Now, coming from SSIS, I am not sure what can be done to run it as 32 bit, maybe you need a parallel installation on the same box using the 32 bit install (or maybe you need to use a separate box). Unfortunately, I have not tried using the SLX OLEDB Provider on this specific situation.
|