I've done a bit of work with DTS and exporting data to Excel, and I get similar error messages that aren't very helpful. Personally I think theres some bugs relating...

Why bother with obtaining an ftp client, when you can simply utilise the ftp command from the command line. This way you can add it in as a seperate task...

I'd have to say I'm divided on the subject.

I've been around IT for a long while (remember the portables back in the early '80s that were bigger than your dad's...

Solart is right - make sure your truncate on checkpoint is switched on so that it empties the tempdb database.

I've had similar issues with my tempdb database being large -...

This issue sounds very similar to what happened to me. It too sounds like a permission problem.

You're able to run the DTS package ok under your login, but not...

I didn't create the app (and I fear there is no source either to check), so unfortunately I can't modify it.

However, I did have a breakthrough with the debugging. I...

Checked the file - looks fine. I've tried referencing it as well - still no joy. System is SQL v7.0 and NT 4.0 (should have mentioned earlier).

One thing I...

Steve,

the line of code looks something like this:

xp_cmdshell 'xcopy d:\temp\*.* e:\temp\*.*'

This line is actually contained within a batch file - when I execute the batch file, everything inside it runs...