Home Forums Data Warehousing Integration Services SSIS 2008 - Need help with expression in derived column. RE: SSIS 2008 - Need help with expression in derived column.

  • October 23, 2014 at 9:45 am

    #1754398

    p.shabbir (10/23/2014)

    Thanks for the reply phil.

    Yes, always there will be 3 items and column length is not fixed.

    It may be varied for example

    ABCDE|ABCDF|BCDEF

    BCDEF|ABCDF|BCDEF

    ABCDEF|ABCDF|BCDEF

    ABCDE|ABCDFE|BCDEF

    Thanks

    Is the data coming from a flat file?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.