Hi All,

I'd like to use Data pump task to transfer my source (CSV file) to the
Destination(Table) ,but I'd like during the transformation if any of columns
is null ,the last column of the row which is a falg to be set.How I could
achieve this.

Thanks

You will, I believe, have to test the column like this

If ISNULL(DTSSource("Col00X")) THEN
'Do something here
End IF



"RayAll" <RayAll (AT) microsft (DOT) com> wrote