May 16, 2011 at 5:41 am
I need to migrate old SQL 2000 databases into a new SQL 2008 R2 server.
however, these old databases use DTS packages to access Lotus notes databases and AS400 DB2 databases.
I didn't find lotus notes odbc 64bit drivers.
How can you continue to access the lotus notes databases with SQL 2008 R2 ?
Thanks for you help
May 16, 2011 at 9:24 am
Short answer, test. Not sure how the 32 bit drivers will work, but I'd install them on a x64 instance and see if you can access things. There is a DTS runtime that you can use in SQL 2008 R2, but I believe that is going away in the next version, so I'd start warning people these need to migrate to SSIS.
May 16, 2011 at 9:56 am
the problem with SQLNotes odbc driver is that there is only 32 bits driver and the 32 bits ODBC Drivers are not visible it in a default SSIS package.
but I think I found a solution, I will test and let you know.
http://msdn.microsoft.com/en-us/library/ms141766.aspx
thanks for your update.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply