Help ! Out of Memory when using Lookups

#1

Hi folks,

I get a "out of memory" error when trying to use lookups in my data
transformation task

the two lookup querries are

SELECT MAX(AddressID) AS Expr1
FROM tblAddresses

and

INSERT INTO tblData
(AddressID, Name, Data)
VALUES (?, ?, ?)

If I delete both lookups then everything works fine..
what can that be?

cheers
Adrian

#2

I've got a similar problem. When I use DTSLookups I get a 'Not enough
storage is available to complete this operation'. This used to work just
fine. I'm wondering if SP1 on Server 2003 has caused this.

What are you running on?

"Adrian" <Adrian.Porger (AT) gmx (DOT) de> wrote

Quote:

Hi folks,

I get a "out of memory" error when trying to use lookups in my data
transformation task

the two lookup querries are

SELECT MAX(AddressID) AS Expr1
FROM tblAddresses

and

INSERT INTO tblData
(AddressID, Name, Data)
VALUES (?, ?, ?)

If I delete both lookups then everything works fine..
what can that be?

cheers
Adrian

#3

I got the same problem, but installed MSSQL SP4, and now it works.

See also : http://support.microsoft.com/default...b;en-us;889170

"Adrian" wrote:

Quote:

Hi folks,

I get a "out of memory" error when trying to use lookups in my data
transformation task

the two lookup querries are

SELECT MAX(AddressID) AS Expr1
FROM tblAddresses

and

INSERT INTO tblData
(AddressID, Name, Data)
VALUES (?, ?, ?)

If I delete both lookups then everything works fine..
what can that be?

cheers
Adrian

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Help ! Out of Memory when using Lookups

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Help ! Out of Memory when using Lookups - 06-23-2005 , 01:55 PM

Re: Help ! Out of Memory when using Lookups - 06-24-2005 , 10:04 AM

RE: Help ! Out of Memory when using Lookups - 06-28-2005 , 05:00 AM