sql server dts: Hello All,

I need to run an external command (secure ftp client) that will return a 0
if successful or 1-8 to signify different error conditions. My DTS job will
need to branch according to the specific return code. I spoke to MS support
and they tell me there is no functionality in DTS that can return th ereturn
code from an external process. They tried to sell me on xp_cmdshell but it
only returns 0 or 1. Have any of you had to do anything similiar? If you
have any ideas I would appreciate hearing them.

Thanks in advance

Steve Skidmore

You could try to save, in the external command, return code to an
environment variable; then read the value with DTS Dynamic Properties Task
component. I haven't tried it so I don't know it works.

I have also read something about Exec method of WshShell WSH class.

"Steve Skidmore" <Steve Skidmore@discussions.microsoft.com> ha scritto nel
messaggio news:94D39E52-4C94-4204-9785-55D52705DD7C@microsoft.com...
[quoted text, click to view]