SQL Server Performance Forum – Threads Archive

DTS Transformation

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.

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/

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.

]]>