Post reply

Conditional split in SSIS

  • June 14, 2013 at 8:14 am

    #273976

    Hi All

    I need help with SSIS Conditional split. I have attached a create tbl script and test data.

    I need to split data in multiple columns so that i can use that data in SSRS. The issue is that the data is mixed up and vary in length

    The column in mind here is "Client_user_agent", the split should have a Browser and Devices column. The first few characters they are terminated with "/" then a number then "(" in here it's either a device or a browser then terminated with ";", so thus far i need data

    I hope it will make sense with test data

    Thanks

    It's better to fail while trying, rather than fail without trying!!!

  • June 25, 2013 at 7:25 am

    #1627104

    Sounds more like you need a few derived columns rather than a conditional spit. You could then take the parts of the string that you need using the SUBSTRING and FINDSTRING commands in SSIS.

    An example is here:

    http://stackoverflow.com/questions/10921645/ssis-how-to-get-part-of-a-string-by-separator

    Best of luck 🙂

    I'm on LinkedIn

  • June 25, 2013 at 10:29 pm

    #1627367

    Thanks will check

    It's better to fail while trying, rather than fail without trying!!!

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

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