What about AUSSQLUG

You don't need to use DTS.

Using xp_cmdshell, execute  ROBOCOPY (from the Windows Resource Kit) to copy the files. You could use standard Copy or XCopy, but ROBOCOPY is a lot...

Brian

What are the chance of getting an RSS feed of forum posts??

You could always get your developers to stop being lazy and write some code

Error trapping is boring whichever way you do it. That's why the majority of people either don't do it at all, or don't...

Here's a couple of candidates

http://images.google.com/imgres?imgurl=http://www.njscuba.net/img-uw/sharks/great_white_4.jpg&imgrefurl=http://www.njscuba.net/biology/sw_fish_sharks_offshore.html&h=375&w=500&sz=44&tbnid=ky-IHgIQoQYJ:&tbnh=95&tbnw=127&start=67&prev=/images%3Fq%3Dsharks%26start%3D60%26hl%3Den%26lr%3D%26sa%3DN

Nooooooooooooo !!!!!

Where are the teeth !!!!!

Does the [ProcessedDate] field get updated once your stored procedure is run?

If so you could create a "driver" stored procedure that use a while loop to call your other stored...

Eerrgghhh !!!

I shudder to think of the uses this can be put to.

Take a look at the examples over at http://www.sqldts.com

Just to add my belated congrats to Frank.

Frank don't change the avatar. You could maybe zoom in a bit more to show more of those gleaming teeth

To get a more descriptive error message, right-click "Database Maintenance Plans" in Enterprise Manager and choose "Maintenance Plan History..."

Choose you plan and scroll down the list to find the errors....

Just call MS Support and explain that you want clarification on the KB article.

Firstly, what has this got to do with DTS?

Secondly, SQL 2000 doesn't support crosstab queries. You can either wait for SQL Server 2005 ...