Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Conditional split in SSIS Expand / Collapse
Author
Message
Posted Friday, June 14, 2013 8:14 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 6:42 AM
Points: 986, Visits: 900
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!!!


  Post Attachments 
Test data.txt (23 views, 2.09 KB)
Table.txt (14 views, 487 bytes)
needed data.png (16 views, 109.25 KB)
Post #1463595
Posted Tuesday, June 25, 2013 7:25 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: 2 days ago @ 4:50 AM
Points: 635, Visits: 1,213
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
Post #1467136
Posted Tuesday, June 25, 2013 10:29 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 6:42 AM
Points: 986, Visits: 900
Thanks will check




It's better to fail while trying, rather than fail without trying!!!
Post #1467445
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse