Hi,

I am trying to load a text file into a table using the data pump task.
The source file can have up to 16 columns but may have less. I always
want to take all the columns and I am sure there must be a way to check
whether a column exists before loading it? I assume there's something
that can be written in Activex along the lines of

Function Main()

IF EXISTS DTSSource("Col015") THEN
DTSDestination("col15") = DTSSource("Col015")

ELSE
DTSDestination("col15") = NULL
END IF


Main = DTSTransformStat_OK
End Function

I've tried IsEmpty and IsNULL with no success. Is there a way to
determine whether a column in the source file exists simply?

Thanks