SQL Server Performance

DTS Transformation

Discussion in 'SQL Server DTS-Related Questions' started by surfNicolas, Apr 11, 2007.

  1. surfNicolas New Member

    I use MS Server 2003 with MS SQL Server 2000. I have written a DTS Package with a transformation between dbase5 and MS SQL Server 2000, using the DTSLookup for referencing another table. This DTSLookup is the origin for an error: not enough memory.

    This problem only occurs on the MS Server 2003! ON an Windows 2000 or Windows XP machine the error doesn't occur. Has someone pls an idea to solve this problem.

  2. dineshasanka Moderator

    can you paste the exact error here.
    Also, check whether physucal memeory and vertual memory are the same with other servers

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  3. satya Moderator

    Do you mean on Windows 2003 server?
    There is no SQL server 2003, either 2000 or 2005.

    See what other jobs are running at the same time.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page