toddasd (6/7/2011)

---

That's a...

SSIS has a built-in FTP task operator. It won't work with SFTP ("Secure" FTP), but if it's vanilla FTP, it should be able to do what you need. ...

Talk to some tech recruiters in your area. BI is a HOT field to break into, but you'll be competing with people with a lot more technical experience at...

And, of course, it can have commas in the text too, can't it?

I think I'd build a custom import engine for this. Any of the various .NET languages should...

I was trying to be humorous, but apparently I missed. Sorry about that.

If you absolutely have to have a string in a specific format, you'll want to define the...

Does this return more than one row in some/all cases?

select NumericValue from ClientSettings where Setting like 'PushMaxCustomerRank'

If so, you'll get that error message, because you really haven't told SQL Server...

markanderson (6/7/2011)

---

On sort of the same front, why is it when you define a field as decimal(6,6), which means that we only want data on the right side of the...

But the account ID is the same (two records have 1, two records have 2).

You have two rows with an account ID of...

Stefan Krzywicki (6/7/2011)

---

GSquared (6/7/2011)

---

GilaMonster (6/7/2011)

---

Now I can look forward to working on fun, interesting, complex stuff (like automating an entire SQL environment from scratch, designing nasty-complex systems for forecasting) rather...

GilaMonster (6/7/2011)

---

Now I can look forward to working on fun, interesting, complex stuff (like automating an entire SQL environment from scratch, designing nasty-complex systems for forecasting) rather than producing lists...

Now that I can easily believe! Won't be the first, nor the last, time that I missed those....

Roy Ernest (6/7/2011)

---

SQLRNNR (6/7/2011)

---

You gonna be wearing a kilt or something similar...

mtillman-921105 (6/7/2011)

---

GSquared (6/7/2011)

---

mtillman-921105 (6/6/2011)

---

Actually GSquared,...

Steve Jones - SSC Editor (6/7/2011)

---

GSquared (6/7/2011)

---

Steve, when you originally envisioned SSC, did you imagine it would end up having debates on the meaning of "philosophy" and the definitions of...

opc.three (6/7/2011)

---

Every iteration done inside the "for each" proc is done on an independent thread so you need to use a global temp table or a permanent table. Try it...