Yeah! Someone else with the same problem! If your SQL install is the 64bit version there are 3rd party bridge software pieces you can buy to bridge from the 64bit environment to the 32bit driver. I have no real suggestions on what works so I won't mention any names. I think all are going to be fairly expensive.
Rocket is working on a 64bit driver but has no ETA yet. If you install the 32bit driver and install a 32bit version of SQL they should work even though you are running a 64bit OS. I say should because we have not yet confirmed it does. We should find out this week if we get time to test it. I suggest calling or emailing rocket software and get on their beta program so you get the 64bit driver as soon as they think they got it working. Jeffrey Lettau ERP Systems Manager polkaudio -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Louise Yang Sent: Tuesday, June 07, 2011 5:25 PM To: 'U2 Users List' Subject: [U2] UniOLEDB and Windows 2008/SQL 2008 I'm trying to migrate SSIS packages from Windows 2003/SQL 2005 to Windows 2008/SQL 2008 and all the packages use UniOLEDB provider which doesn't' work with 64-bit Windows 2008. Any suggestions? -Louise Yang _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ________________________________ Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
