I want to use DTS to add records to a Lotus Notes Address
book from a SQL Server table. I have downloaded the
NotesSQL 3.02g ODBC driver and installed it successfully.
I am able to view the Notes address book data and delete
from the Person table in the Notes address book. When I
try to insert rows into the Person table I get the
following error in the data pump exception log:

Error at Destination for Row number 1. Errors encountered
so far in this task: 1.
Error code: 80004005 Person|:
User|User (AT) company (DOT) com||J|R|User|User|||User||||3|||||User@c
ompany.com|||1|0|||BMP||||||||||000-000-
0000|||||||||||||||||||||||||||||||||||||||||||||| |||0|||CN
=Test User/OU=HFC/O=HFC_Corp||CN=Test
User/OU=HFC/O=HFC_Corp||0|1|0||0||||None|J|R|User|User||||U
ser|||||3|||||User (AT) company (DOT) com|||1|0|||BMP|||||000-000-
0000|||||||||||||||||||||||||||||||||||||||||||||| ||||||||0
User/HFC/HFC_Corp|0|0|0||||||||||||None|[UserModifier]
src='/HFCSub.nsf/WebJSNavigationTools?
OpenJavaScriptLibrary'></script> <script> sWebDbName
= '/HFCSub.nsf/'; ntReturn(); </script>|3/18/2005
11:00:21 AM|||||||||||||||||||||||||||||||||
Person|:
User|User (AT) company (DOT) com||J|R|User|Neaves|||User||||3|||||User
@company.com|||1|0|||BMP||||||||||000-000-
0000|||||||||||||||||||||||||||||||||||||||||||||| |||0|||CN
=Test User/OU=HFC/O=HFC_Corp||CN=Test
User/OU=HFC/O=HFC_Corp||0|1|0||0||||None|J|R|User|User||||U
ser|||||3|||||User (AT) company (DOT) com|||1|0|||BMP|||||000-000-
0000|||||||||||||||||||||||||||||||||||||||||||||| ||||||||0
User/HFC/HFC_Corp|0|0|0||||||||||||None|[UserModifier]
src='/HFCSub.nsf/WebJSNavigationTools?
OpenJavaScriptLibrary'></script> <script> sWebDbName
= '/HFCSub.nsf/'; ntReturn(); </script>|3/18/2005
11:00:21 AM|||||||||||||||||||||||||||||||||


Has anyone been able to successfully perform this type of
DTS task?

Thanks in advance!!!

Scott Lindsey wrote:
I have not inserted records into a Notes database, but I do use NotesSQL to read
from a Notes db into SQL Server db. I could not get version 3.02 to work
properly, so I went back to 3.01 version. No problems with that.

Ed