So do you have any alternatives to his thoughts on how he has to process his updates / inserts? Or does he have the order correct?

To prove my professionalism, I shall respond to your comments in...

Given the form of your question, I assume you're looking for a tool?

Try SSIS. It has an FTP task within the tool (which is why there's some confusion) and it...

To further explain what Mike was saying:

In computing, NULL means unknown. Not nothing. Not zero. It means "I don't know the value of this variable/object." Since the value is not...

It's in the connections manager property of your package. SSIS packages create and drop multiple connections when running, which kills your temp table before you've had a chance to use...

I'm glad you found the solution and thank you for posting it. It will help others.

WOTD: New

Oh, that looks...

I have, on several occasions, asked stupid or trick questions of potential co-workers during the interview process. I want to see how they react, how seriously they take the question,...

Hey 2k8 T-SQL experts, need a little bit of advice on this topic: http://www.sqlservercentral.com/Forums/Topic1059305-391-1.aspx?Update=1. It's a follow up to a schema design question.

I know there's a fancy T-SQL construct for...

It would be something like that. But I believe SQL 2K8 has access to more advanced query language (I'm still on 2k5) that would allow you to Insert and Update...

Yep. That's correct.

I'd need help setting up, but I wouldn't mind virtual presentations. Though, if a chapter is willing to pay for travel costs (or I'm in the area), I'd be willing...

Michael Valentine Jones (2/8/2011)

---

I think some companies want a college degree just to make sure that you can read and write, since a high school diploma doesn’t seem to ensure...

Okay, I have to ask. Did you mean "paltry"...