Access lotus notes database with SQL 2008 R2

• fabrice_dossmann

  Valued Member

  Points: 74

  More actions

  May 16, 2011 at 5:41 am

  #240338

  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

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738043

  More actions

  May 16, 2011 at 9:24 am

  #1325180

  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.

• fabrice_dossmann

  Valued Member

  Points: 74

  More actions

  May 16, 2011 at 9:56 am

  #1325218

  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.