First, is Add1 a column or a variable?

Secondly, we can not convert this to a Stored Procedure (which is like...

[h2]Uurrrpp![/h2]

Done:

The are two different formats for the CASE function:

1:

CASE [valueExpr1] WHEN [valueExpr2] THEN [valueExpr3]

This format compares [valueExpr1] to the value expression after each WHEN clause and if true...

When you are using FOR XML to do string concatention,...

Shawn Therrien (5/12/2009)

---

Okay, that sounds easier than I thought. Just do the import for one, but make sure you're using the Package Configuration to store all the variables like server...

Hmm, Im not sure, actually...

What I was talking about is one package with a source CM (connection manager) pointing to one of your four sources and sending the data to...

Actually, I have seen perfectly valid reasons for having both the extracted subfields and the whole address as originally input.

The crux of it is that addresses are notoriously dirty, mangy...

Well I can only read the words...

I don't know about any GUI for the user, but as far as retargeting an SSIS package, that is usually done through Configurations. I do this all the time,...

UncleJimBob (5/12/2009)

---

I have seen similar examples of ROW_NUMBER() usage and the following has always puzzled me:

Why do we include columns in the ORDER BY when they are already in the...

Bob Hovious (5/12/2009)

---

...

You know I love the ladies: silver, gold, blue or green,

Hot pink, fluorescent purple, and some shades in between.

I charm them and disarm them, if you know...

Glad I could help!

Dang. That's amazing, Gail. :w00t:

You can do this, either with specialized Software and Hardware (actually, you may not need the HW anymore), or alternatively, I beleive that there are psecialized services on the Internet...