Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-26 : 09:12:10
|
| John Niemiec writes "I cannot seem to export information to a Lotus Notes database from SQL Server 7.0, even though I have the connection setup.I have a SQL task setup to delete records (documents), but cannot get the transformation to the output data source (a Lotus notes database, same one used for the delete) to work. Any clues, cause I am clueless why I can delete, but the add fails on the first record, giving no information other thanerror occured, row 1.john niemiec" |
|
|
Jay99
468 Posts |
Posted - 2002-03-26 : 09:52:49
|
| Please provide either more details or more money (joking).Like, how is the connection set up, what is the DataSource, is it via an ODBC driver, what are the ODBC settings, what user accounts and security considerations are there, what is the dml you are able to execute, what is the dml you are not able to execute, what is the code in your sql task, are you trying to use a sql task to do the insert, are you using a data pump task, what service pack are you on, what network protocols are you using, etc etc etc.Jay<O>Edited by - Jay99 on 03/26/2002 10:57:57 |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-26 : 10:01:12
|
Actually, the money would be nice, but isn't mandatory!  We do need some more information though. |
|
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-03-26 : 11:44:46
|
| I myself have experienced great pain with Lotus Notes and DTS. First it needs to be said that Lotus Notes is not a database product. There are no such things as 'Notes databases'. Lotus Notes is a record management product, in the same vein as a Btrieve, for example. There are many, many painful differences: lack of keys, lack of relational constraints, no real domain integrity ...I wish you the best of luck as you tread down the path of hopelessness. Putting data INTO a Notes system from SQL Server is throwing good money after bad; doubtless you know this already.Now, you haven't provided much detail but I would imagine you are using ODBC to connect to Notes. ODBC has a rich debugging capability that will provide more information than the nondescript error you are getting through the driver. That might be a good start.setBasedIsTheTruepath<O> |
|
|
|
|
|
|
|
|
Lotus Notes and DTS