Better option is to wrap your call to xp_cmdshell in your own stored procedure that returns a success/failure via an output parameter. Then you can pick it up using the...

Presuming you want to get a list of the SQL Servers in a DTS package? If so, you'll need to write a short VBScript to trawl through the DTS object...

Have tried looking at the execution from Profiler? It might uncover whats going wrong?

Don't know if this suit you needs, but how about trying this?

http://www.sqldts.com/default.aspx?237

If that doesn't fit then there is a workaround here,

http://www.sqldts.com/default.aspx?297

Hmmm ... smells like a permissioning issue.

Are the services on the production server running with the same level of permissions as the test server?

You could also look at Microsoft's new SQL Health and History tool.

This tool captures information about the Server and Database and with the add-on Performance collecter, it captures any Performance...

Ok, so it's using the SSNETLIB.DLL, but as shown by this line

"2005-05-03 15:32:30.26 server SQL server listening on Shared Memory, Named Pipes."

The server is NOT listening on TCP so therefore...

Funny, there's no pain involved when I run a DTS package from a stored procedure. Then again, I've always thought my system was magical. It does seem to easily do...

You already have the filename and extension in the sSourceFile variable. So what you can do is use the GetBaseName and GetEstensionName methods to build a new file name for...

What error are you getting? The code snippet below will show a message box with the error.

On Error Resume Next
oFSO.MoveFile sSourceFile, sDestinationFile
If Err.Number <> 0 Then
    MsgBox "ERROR: "...

A couple of potential problems from the log,

"2005-05-03 15:32:30.26 server SQL server listening on Shared Memory, Named Pipes."

You might need to enable the TCP/IP protocol before SQL will listen on...

A service running as a system account has no privelages for any networked resources.

So are you trying to rename the file in a folder, or change the source filename for a connection?

To change the filename in a folder, there isn't a file rename...

Did you just clear the eight rows or explicitly delete them? I've had problems like this previously where people where just highlighting what they wanted to remove and pressing delete....

How much data are you exporting? If it's not a huge number of rows you could quite easily use DTS to output to a text destination. BCP is faster on text...