Friday, February 17, 2012

Extracting Data from lotusNotes into SQL SERVER

I have a form in Notes that is huge. I need to extract a part/field from that form into SQL SERVER. If I use NotesSQL Thru SQL DTSPackages, I am afraid it will run very long. Is there any other option on that?

Any help is appreciated.

Are you using the Notes ODBC driver at all? If not, you can use that along with a DataReader source in SSIS.|||

you need the right connector to be able to deal with the Notes as a source/destination. Please check our Data Sources matrix in our connectivity wiki to see possible alternatives for Lotus Notes integration:

http://ssis.wik.is/Data_Sources

No comments:

Post a Comment