Help ! Out of Memory when using Lookups

Tech-Archive recommends: Fix windows errors by optimizing your registry



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


.