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 1:00 pm

    #1754473

    Phil Parkin (10/23/2014)

    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?

    OK yeah when it is the only delimiter of course not 😀

    I was referring to the case where you have a column with different delimiters that needs to be splitted as well.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP