Post reply

What data flow transformation task to use ?

  • January 12, 2007 at 4:29 pm

    #368720

    I need to load data from a flat file with pipe delimited columns. As a source I am using Flat File Source object, that's fine.

    However I need to do some values conversion on the fly. For some columns if there is ? mark - I have to replace it with Null, for other columns I have to replace Yes with 1 and No with 0 ( they are boolean values), and for some others I have to replace Null with zero-length string.

    I checked Character map, Copy column, Data Conversion tasks but none of them seems to have conditional conversion.

    Any idea ?

    Thanks

     

  • January 15, 2007 at 6:08 am

    #683192

    You want to use a "Derived column" transformation.

  • January 21, 2007 at 1:36 pm

    #684582

    If you have several columns you can also use the "Script Component' and regular expression patterns. I provide a video and sample code to do this at http://www.jumpstarttv.com/Media.aspx?vid=72.

    [font="Comic Sans MS"]Ira Warren Whiteside[/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply