NULLS --> blanks ?

I wrote a simple data flow with an OLE DB source and destination. I do a direct mapping of the columns ( colA - > colA) with no transformations needed. I found that colA on the destinatin does not allow NULLS (required by the program that accesses that database) while colA on the source supports and has NULLs, Is there any accomodaiton for handling NULLS (like mapping them to blanks) in the direct copy approach or do I need to read each row and test colA_ISNull?

TIA,

barkingdog

There is no way of dealing with them other than testing them for nullability and changing them accordingly.

This is easily achieved with a Derived Column component.

-Jamie

|||

>>>> This is easily achieved with a Derived Column component.

Excellent suggestion!. I acomplsihed the same thing but with a more arduous Script task. A Derived Column seems like a much better approach.

Thanks,

Barkingdog