Post reply

Use Like operator in Conditional split task

  • January 6, 2009 at 9:20 am

    #204713

    Hi,

    Suppose, I want to find and split records which contain any letter(A-Z) in conditional split task.

  • January 6, 2009 at 12:33 pm

    #922053

    Conditional split is good for this stuff, but it is not very easy for your example in ssis 2005.

    If you want to use conditional split you only have the findsting function available.

    It is case sensitive and you cannot use wildcard, or the simple [a-z].

    You can put a logical or || for each letter . ie FINDSTRING(Col2,"a",1) > 0 || FINDSTRING(Col2,"b",1) > 0 || FINDSTRING(Col2,"c",1) > 0. but doesn't look very good.

    You can try to download and use a custom transform.

    if you know RegEx

    http://www.sqlis.com/post/Regular-Expression-Transformation.aspx

    or you can try to use a script transformation and evaluate the data using Code.

    http://www.sqlis.com/post/The-Script-Component-as-a-Transformation.aspx

    Or simply pump the raw data into a file and use T-Sql tasks to move your data around.

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

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