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 12:26 pm

    #1754466

    Koen Verbeeck (10/23/2014)

    Phil Parkin (10/23/2014)

    Configure your flat file source connection with | as the column delimiter and let SSIS do the work for you. See here[/url] for an example.

    Or just create a very simple script component that uses the .NET split function.

    Very easy to work with and much easier code to write.

    Easier than 'none'? How so?

    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.