I have a fact table with the same granularity. I have an Invoice Header dimension. In my design, I would add that in this dimension.

ericpap (6/11/2015)

---

Alvin Ramard (6/11/2015)

---

Eric M Russell (6/11/2015)

---

Somehow I feel we're missing a lot of the back story; does this level of anarchy really happen in the IT departments of corporate...

Eric M Russell (6/11/2015)

---

Somehow I feel we're missing a lot of the back story; does this level of anarchy really happen in the IT departments of corporate or government world?...

Shadab Shah (6/11/2015)

---

Alvin Ramard (6/10/2015)

---

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...

kferrara (6/10/2015)

---

Has anybody encountered this problem? I'm connecting to an Oracle database via both SQL Developer and SSIS using the Native OLE DB\Oracle Provider for OLEDB. I am...

I have no idea what you're looking for. Can you reword your request?

Only things I can think of right now is make sure each derived column name is correctly spelled and always has the same case. Address_1 and address_1 may be considered...

W4Designs (6/10/2015)

---

I found the problem. It was where the " " was towards the end of address_2. It needed to be moved over a flew places from where it was.

It...

ericpap (6/10/2015)

---

ok. The more deep I digg, the worst it smells... This starts to feel like a CSI show...

In the session on the user that stopped the service, i found...

...

W4Designs (6/10/2015)

---

Alvin Ramard (6/10/2015)FINDSTRING and CHARINDEX don't work the same way. 😉

Try:

Address_1:

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

Address_2:

SUBSTRING(Street,LEN(address_1) + 1,50 - FINDSTRING(REVERSE(SUBSTRING(Street,LEN(address_1) + 1, " ",50)),1))

Address_3:

SUBSTRING(Street,LEN(address_1) + LEN(address_2) + 1,50...

W4Designs (6/10/2015)

---

ok, this is what I have now and it does run. but the data is weird:

Address_1:

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

Address_2:

SUBSTRING(Street,LEN(address_1) + 1,50 - FINDSTRING(" ",REVERSE(SUBSTRING(Street,LEN(address_1) + 1,50)),1))

Address_3:

SUBSTRING(Street,LEN(address_1) + LEN(address_2) +...

Ok. Then make sure that you drag the new column name (Address_1 & Address_2) from the column...

I haven't.

W4Designs (6/10/2015)

---

It doesn't like address_2 and address_3. Those are actually what the derived fields are named: Address_1, address_2, address_3. The primary field is called Street. Here's how I modified yours...