Well, I never use the wizard, and...

See if this works:

Street1: SUBSTRING(Street,1,50 - FINDSTRING(" ",REVERSE(SUBSTRING(Street,1,50)),1))

Street2: SUBSTRING(Street,LEN(Street1) + 1, 50 - FINDSTRING(" ",REVERSE(SUBSTRING(Street,LEN(Street1) + 1,50)),1))

Street3: SUBSTRING(Street,LEN(Street1) + LEN(Street2) + 1, 50 - FINDSTRING(" ",REVERSE(SUBSTRING(Street,LEN(Street2) + 1,50)),1))

This...

The syntax I posted is all SQL. If I'm not mistaken, FINDSTRING might be what you need to use instead of CHARINDEX in SSIS expressions.

W4Designs (6/10/2015)

---

Thanks Alvin!

My supervisor-imposed requirement is that I NOT use SQL to do the conversion and to use some alternative method inside the package. Obviously SQL is the most simple...

If #Temp2 had a RowNumber column, with values that reset to 1 for each grouping, then in your update statement, you can add the join on the row number to...

You could try something like the code below, in the query that extracts the data from your source table.

SELECT

CHARINDEX( ' ',REVERSE(yourAddressField), 1),

Street1 = SUBSTRING(yourAddressField, 1, 50 - CHARINDEX(...

I'll have a solution for doing did in the SQL query after I come back from lunch.

All the records of #Temp2 were updated when I ran your scripts.

Eugene Elutin (6/10/2015)

---

Have you heard about data normalization?

I would suggest to do exactly that.

Store data in the database table as supposed to; report/display it as you wish (comma separated...

I hope this is a homework question. I have trouble imagining the data presented as realistic.

David Burrows (6/10/2015)

---

This might be possible using derived columns but would be a very complex expression or using several derived columns to pad the string into 50 column chunks and...

Eric M Russell (6/9/2015)

---

Alvin Ramard (6/9/2015)

---

Matt Miller (#4) (6/9/2015)

---

Yes - agreed Eric.

Clearly have a profile on LinkedIn, but making massive changes and/or listing yourself as looking for work...

ricardo_chicas (6/9/2015)

---

Hello All

I have a 50gb database, with 3 files at the primary filegroup, each one of those has around 16gb

I truncated 2 tables releasing 33gb, so the database should...

Matt Miller (#4) (6/9/2015)

---

Yes - agreed Eric.

Clearly have a profile on LinkedIn, but making massive changes and/or listing yourself as looking for work in this scenario might cause...

sharonsql2013 (6/9/2015)

---

I am a bit confused on the logic..

If we need to calculate the Percentage of Closed Purchase Orders .

Does that mean we need to implement like this ?

SUM(of Purchase...