It looks like you've posted your question in the wrong forum. This forum is for backup related issues and your query doesn't look like it's saving backups or doing restores.

I'm...

Oh, this sounds like a Question of the Day scenario. One of you should totally send this in.

Post the query you're using and we'll see what we can see.

I forgot to ask. What is the exact text of the error you're getting?

One thing that may help (in the long run) is to come up with a DOs and DON'Ts list (Database standards). If you're cleaning up the code, you know the...

I advise using SSIS. You can set up filenames using expressions in SSIS and make it repeatable.

Ninja's_RGR'us (2/9/2011)

---

One more option maybe the op didn't consider.

Do you have by any chance a copy of the script you use the create or load the table? In that...

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