Scheduling DTS datapump from Lotus Notes - Password problem

• dbuchan

  SSCrazy

  Points: 2278

  More actions

  December 1, 2004 at 11:06 pm

  #60264

  A scheduled DTS job will not complete because it is requiring the Lotus Notes password to be entered to connect.

  Is there some way (apart from using a Notes Id that has no password) to avoid the requirement for an operator to enter the password ?

  I know zilch about Notes, so if you need more info please ask away.

  Notesql has been installed on the SQL Server. The ODBC DSN works fine (manually entering password).

  Regards all,

  DB

  
  The systems fine with no users loggged in. Can we keep it that way ?br>

• John R. Hanson

  SSC-Addicted

  Points: 441

  More actions

  December 3, 2004 at 9:49 am

  #532504

  See if you can create a UDL that has the password then use the UDL for your DTS Connection. See the following Article on How to...

  http://www.databasejournal.com/features/mssql/article.php/3100661

  Cheers,

  John R. Hanson