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@company.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@company.com|||1|0|||BMP|||||000-000-
0000||||||||||||||||||||||||||||||||||||||||||||||||||||||0
||0|||||||||||||CN=Test User/OU=HFC/O=HFC_Corp|CN=Test
User/OU=HFC/O=HFC_Corp|1|02/10/2005 03:28:35 PM Test
User/HFC/HFC_Corp|0|0|0||||||||||||None|[UserModifier]
|<link rel=stylesheet type='text/css'
href='/HFCSub.nsf/cssForm?ReadForm'> <script
src='/HFCSub.nsf/WebJSNavigationTools?
OpenJavaScriptLibrary'></script> <script> sWebDbName
= '/HFCSub.nsf/'; ntReturn(); </script>|3/18/2005
11:00:21 AM|||||||||||||||||||||||||||||||||
Person|:
User|User@company.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@company.com|||1|0|||BMP|||||000-000-
0000||||||||||||||||||||||||||||||||||||||||||||||||||||||0
||0|||||||||||||CN=Test User/OU=HFC/O=HFC_Corp|CN=Test
User/OU=HFC/O=HFC_Corp|1|02/10/2005 03:28:35 PM Test
User/HFC/HFC_Corp|0|0|0||||||||||||None|[UserModifier]
|<link rel=stylesheet type='text/css'
href='/HFCSub.nsf/cssForm?ReadForm'> <script
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?

[quoted text, click to view]

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.