x

split data delimited by character

Hello I really would appreciate someone`s help I`m a newbee in all of this SQL-SSIS stuff I have the following table in SQL: alt text

And I need to create a table with columns that contain the AreaPath column and parsed by the delimiter “\” Meaning my final goal is this: alt text

Couple of important things: 1. The original table is constantly changing (every 10 minutes) 2. I have SQL 2014 3. I can use SSIS to do so (I prefer to, then SQL)

original-table.png (32.2 kB)
desired-table.png (102.4 kB)
more ▼

asked Jan 11 at 09:14 AM in Default

avatar image

NewPersonSSIS
1

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Hi, Try using the FINDSTRING function in SSIS (found in the Derived Column transformation) see here and here

more ▼

answered Jan 11 at 10:18 AM

avatar image

tzvikl
31 3

(comments are locked)
10|1200 characters needed characters left

Thanks!I have managed to do it using the TOKEN function in SSIS!

more ▼

answered Jan 11 at 01:16 PM

avatar image

NewPersonSSIS
1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1244
x1205

asked: Jan 11 at 09:14 AM

Seen: 48 times

Last Updated: Jan 11 at 01:16 PM

Copyright 2018 Redgate Software. Privacy Policy