Results 1 to 6 of 6
  1. #1
    Join Date
    May 2004
    Posts
    15

    Exclamation Unanswered: OBBC / DTS Error

    Hi, i am trying to import data from a 400 column Lotus Domino view into a SQL Server table (vie an ODBC System DSN). However, the dts job that i am running keeps giving me the following error:

    "[Lotus][ODBC Lotus Notes]Memory Allocation Failure".

    I have tried cutting the sql table down to 2 columns, but the transformation still falls over. I think this is a problem with the amount of virtual memory on the SQL Server 2000 box, but am not sure. Any help would be greatly appreciated. Thanks


    David

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Look for any events in event viewer log during this operation.
    Is the server shared by any other resources apart from SQL server?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    May 2004
    Posts
    15
    Quote Originally Posted by Satya
    Look for any events in event viewer log during this operation.
    Is the server shared by any other resources apart from SQL server?
    Yes, the server (WIn 2000 Server OS) has SQL Server 2000 and Notes Domino 6 server installed. The Domino Server has been upgraded from version 5 in the last few days.

    Will check out the event log, thanks.

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    What was the memory settings on SQL?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    May 2004
    Posts
    15
    Quote Originally Posted by Satya
    What was the memory settings on SQL?
    Total Physical memory 1.5 gB ram
    Available physical mem 67,000 KB
    Total Virtual Memory 5.3 gB
    Available Virtual mem 2.4 gB
    Page File space 3.7 gB

    This is the memory status for the entire server, not just the SQL partition. Event viewer didnt register anything noteworthy.

  6. #6
    Join Date
    May 2004
    Posts
    15

    Exclamation

    can anybody help ? sorry for bumping this up the list but i am now panicking !

Posting Permissions

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