dbTalk Databases Forums  

return codes from external processes

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss return codes from external processes in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Steve Skidmore
 
Posts: n/a

Default return codes from external processes - 02-10-2005 , 11:25 AM






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


Reply With Quote
  #2  
Old   
Massimiliano Melega
 
Posts: n/a

Default Re: return codes from external processes - 02-10-2005 , 12:24 PM






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 (AT) discussions (DOT) microsoft.com> ha scritto nel
messaggio news:94D39E52-4C94-4204-9785-55D52705DD7C (AT) microsoft (DOT) com...
Quote:
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




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.