I am using Transform Data Task to transform data from table to text file. I
am using lookup query to get the value of a single column using VBScript in
transform data task. But when I test the particular VBScript task it gives me
the following error

Error Code:0
Error Source: Microsoft VBScript runtime error
Error Description: Out of Memory

Any Idea on how to resolve the error?
--
Thanks
Akber.

Akber wrote:
That can't be all right... error code 0 means no error.

Ryan thanks for the response.

But that is what SQL Server DTS is showing me the error.
However I have identified and resolved the problem.
The problem was that whenever the VBScript Transformation in Data Transform
Data Task encounters a null value from the source column and it tries to pass
that value to the lookup query it fails. The resolution was to first check if
the source column value is null, if yes then do what ever suites ur
requirement. Either to ignore that value or replace it with some constant and
then pass it to ur lookup query.


"Ryan Walberg [MCSD]" wrote: