July 1, 2008 at 3:19 am
Hello,
Can SSIS convert lotus notes data to SQL Server 2005
What are the steps involved, what are the limitations
Thanks,
Shivali
July 1, 2008 at 3:36 am
As far as my unverstanding goes we do not have any support in SSIS 2005 for Lotus Notes.
go thr this link
http://blog.datainspirations.com/2006/08/14/integration-services-miscellany.aspx
July 1, 2008 at 7:25 am
SrikanthSv (7/1/2008)
go thr this link
http://blog.datainspirations.com/2006/08/14/integration-services-miscellany.aspx%5B/quote%5D
I accept with Srinkanth. It is my personal experience that the SSIS are not supporting for Lotus notes. SSIS recognise the lotus notes db( Lotus notes db means I am talking about .nsf file). My problem is that for some of tables, total rows are not pulling from the source tables. If I use the DTS packages, then every thing is working fine.
Thank You
July 10, 2008 at 7:08 am
Shivali
It is possible to extract data from a Lotus Notes database view - this gets treated like a table and you can select which columns you want.
In order to do it, you will need to install the Lotus Notes SQL ODBC Driver and set up a Connection Manager to point to the new DSN.
Good luck!
Chris
Do not write in this space.
June 1, 2009 at 2:23 pm
Could you explain how one would do that? I've been trying for 2 days now. It appears that the MS support for normal ODBC connections has been removed in SSIS. dotNet ODBC is there instead. Unfortunately it looks like the doNet ODBC driver looks at a different metadata structure than the normal ODBC would. THe error message is: "Descriptor Type out of Range". It won't even let you manually map the fields and force it.
June 2, 2009 at 1:52 pm
Barring any better ideas, I've done an ugly.
I used Access as a conduit.
Using Access linked tables back to the LN database and then SSIS to access
the Access databsee, I have sucessfully imported LN data into SQL Server.
Like I said "ugly".
This may work with a lot of other ODBC situations that MS won't support.
December 5, 2011 at 7:52 am
Too late for this question, but maybe interesting for other users: Convert to SQL for Lotus notes data: http://www.lialis.com/lotussolutionprovider.nsf/pages/convertnotesdatatosql
Free evaluation version download: http://www.lialis.com/Applications/AppDownloadStore.nsf/68e17123e94bae7985256b150071ec6b/030b721d5a8503b2c125781d003b29f7?OpenDocument
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply