Are you sure the H drive is valid and the directories exist? I'm not sure that restore will create new directories.

Also do you need the REPLACE option as well?

DTS usually uses a form of BCP to do the loads.  If you don't care about transaction control, then first remove the indexes on the table and the load operation...

getdate() gives you current date time... converting (convert) it to string and trimming off (substring) the time portion will give you todays calendar date which you can look for all >=......

You might want to post the full script, this piece doesn't do anything that would generate that error.

You're not being clear enough...

Is the update being blocked by another process (live lock)?  Or is it (perhaps) the only thing running at the time when it hangs?

Then supposing you...

Permanent tables is the way to go if you're going to keep track of status/completion info...

The ## tables have worked for me in multi step DTS packages as long as...

1st, back in version 7 (I believe) the powers that be decided that you can't say x = null instead you have to say x IS NULL (stupid I think).

As...

I didn't go looking for that script (if you want people to know, post the exact URL)...

but maybe your problem is matching a guid value in a key... if so...

"After all, bad code (far too much!!!) is already written without this construct"

And now this "far too much" will increase exponentially with this and other language additions. 

As far as...

And this is the nature of the issue:

Put a "feature" which enables (theoretically) handling of sloppy code and the result WILL BE more--many, many times more-- sloppy code.  Guaranteed by...

I have no idea, but in my experience....

The upper echelons of corporations hold the purse strings and so they are much more willing to throw around a million or two...

ayecarumba... they are going to spread the black plague of try/catch error handling to TSQL... yikes!

This is the "I'm too lazy to write good code so I'll just dump it...

This is a shot in the dark because I don't have time to remember how all that works, but...

Since your datatype is NTEXT shouldn't your statement use the "N" prefix...

It's not clear what you're really asking but perhaps what you're looking for is (are) views.

You can create a view which has all the columns in the base table but...

My point was made earlier, the questions I posed were not responded to, and the discussion digressed into threads of "what is coalesce", and some flaming... 

(and I got really...