July 7, 2010 at 9:00 am
Hi everybody.
I want to know how can migrate data from lotus notes 8.5 to sql server 2005 using ssis 2005. I've reviewed that and I didn't find any connector for doing that.
If anyone know how can I solve this problem, please tell me how. 😉
July 7, 2010 at 9:53 am
I admit I've never seen such a move requested. What are you pulling out of Notes? How are you planning to transform it? You might find an OLE DB driver but I'm not sure. That is where I would start, look for an OLE DB driver and see whats out there.
CEWII
July 7, 2010 at 2:13 pm
I know that so I've found a oledb conector called NotesSQL ODBC but I need the lotus client so I found this link http://www.builderau.com.au/architect/database/soa/Create-an-ODBC-connection-to-a-Lotus-Notes-database/0,339024547,320282240,00.htm but I'm not sure this way will help me to connect lotus to ssis 2005.
I want more help.
July 7, 2010 at 3:10 pm
Once you have some connectivity to notes then you can use the ODBC connection in SSIS, but you need to get that in place first.
You might look and see what software this is refering to:
CEWII
July 9, 2010 at 10:14 am
Hi. I've installed lotus client and create the connection odbc but it let me only migrate data to Access.
I need to do this with sql server 2005. Any suggest how to solve it?
July 9, 2010 at 10:23 am
What do you mean it only lets you migrate to Access? Can you set this as a source in SSIS?
July 13, 2010 at 3:00 pm
well, this is the scenary.
I want to migrate data from Lotus Notes 8.0 to Sql Server 2005 using SSIS 2005. I've installed LotusNotes Sql 8.0 but this only let me to connect LotusNotes to Access and when I try to create a odbc connection dns system in control panel of my computer I get the error: "The setup routines for the Lotus Notes SQL Driver (*.nsf) ODBC driver could not be loaded due to system error code 126" .
I've found and read many webpages and somebody write they used LotusNotes Sql 3.0. Actually I need help to resolve it.
Any ideas?
July 13, 2010 at 3:25 pm
It's still not clear. How does Access even come into play? If you can see the Lotus database as a connection, you connect to it in SSIS. If you cannot get an ODBC driver to connect to Lotus, it's likely something in your Lotus driver and you should contact IBM.
If you can get data to Access, move the data there and import it from there into SQL. That's easy.
If you can get an ODBC connection in SSIS, you use that and set another connection to SQL SErver to move the data.
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply