Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    1

    Question Unanswered: DTS and Lotus Notes

    I attempted to do a Transformation DataPump between SQL
    Server and Lotus Notes and DTS returns "error occurred at
    Destination", no further details are provided. The
    NotesSQL driver does not appear to like the Insert
    statement that DTS is generating. Has DTS been proven to
    work using Lotus Notes as a destination? Thanks for any advise.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    You do know that a lotus notes "database" isa not a database. And since your working with a database, you must have some Lotus Notes "guru" who is pushing for this, why not let them use notrix or pump to get the data.

    Deliver a comma delimted file to a location everyday...what? they want real time updates?

    How do you do that to a non relational architecture?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Mar 2004
    Posts
    1

    Re: DTS and Lotus Notes

    Originally posted by sch5479
    I attempted to do a Transformation DataPump between SQL
    Server and Lotus Notes and DTS returns "error occurred at
    Destination", no further details are provided. The
    NotesSQL driver does not appear to like the Insert
    statement that DTS is generating. Has DTS been proven to
    work using Lotus Notes as a destination? Thanks for any advise.
    Why not have the Lotus Notes people setup the DESC sub-system within Lotus Domino and have the system directly access the information wither live or timed?


    Frank

  4. #4
    Join Date
    Aug 2004
    Location
    Hampshire, UK
    Posts
    2

    Notes relational DB

    While Notes Databases arn't relational don't see why that DTS has a problem as you can get Crystal report to run against notes data. Personally I wouldn't touch Notrix my preference has always been to get the Domino application to access the data it needs using LotusScript and ODBC which just makes SQL queries to the data.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •