dbTalk Databases Forums  

using an excute process task

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


Discuss using an excute process task in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
simon whale
 
Posts: n/a

Default using an excute process task - 12-08-2003 , 05:19 AM






Hi all,

i am trying to use an execute process task to connect to an ftp site and
upload some info. but am getting the following error

"CreatedProcessTask 'DTSTask_DTSCreatedProcessTask_3': Process returned
code2, which does not match the specified SuccessReturnCode of 0."

i am using an .cm file to execute the following info

sleep 60
ftp -s:ftpscript.txt www.ukdatait.co.uk

in the script file is the following minus the user name and password for
obivious reasons......

username
password
cd /web/protected/cgi-bin/ppFolder
put sgard.zip
quit

but if i run this manually, no problems the file is put onto the ftp site.
but i am after this as part of the automation process. can anybody help?

Many thanks
Simon Whale



Reply With Quote
  #2  
Old   
simon whale
 
Posts: n/a

Default Re: using an excute process task - 12-08-2003 , 10:50 AM






Fixed it..

in the ftp script i changed

put sgard.zip

to put c:\silentgard\sgard.zip and these seemed to work. and removed the
sleep command

Simon
"simon whale" <simon (AT) nospam (DOT) ukdatait.co.uk> wrote

Quote:
Hi all,

i am trying to use an execute process task to connect to an ftp site and
upload some info. but am getting the following error

"CreatedProcessTask 'DTSTask_DTSCreatedProcessTask_3': Process returned
code2, which does not match the specified SuccessReturnCode of 0."

i am using an .cm file to execute the following info

sleep 60
ftp -s:ftpscript.txt www.ukdatait.co.uk

in the script file is the following minus the user name and password for
obivious reasons......

username
password
cd /web/protected/cgi-bin/ppFolder
put sgard.zip
quit

but if i run this manually, no problems the file is put onto the ftp site.
but i am after this as part of the automation process. can anybody help?

Many thanks
Simon Whale





Reply With Quote
  #3  
Old   
Don R. Watters
 
Posts: n/a

Default Re: using an excute process task - 12-08-2003 , 11:05 AM



Hi Simon,

It's probably just the appearance of it running correctly in the manual
execution. Have you logged the return code of the command file to determine
if you are indeed successfully ftp'ing the file when you run it manually?
Is the file successfully uploaded in the DTS package, even though this error
code is returned? If the file is uploaded successfully then you can change
the execute process task to expect a return code of 2. BTW, you might want
to issue a bin to change the mode from ascii to binary. That could in fact
be the issue. HTH.

--
Regards,

Don R. Watters
Data Group Manager
PhotoWorks, Inc.


"simon whale" <simon (AT) nospam (DOT) ukdatait.co.uk> wrote

Quote:
Hi all,

i am trying to use an execute process task to connect to an ftp site and
upload some info. but am getting the following error

"CreatedProcessTask 'DTSTask_DTSCreatedProcessTask_3': Process returned
code2, which does not match the specified SuccessReturnCode of 0."

i am using an .cm file to execute the following info

sleep 60
ftp -s:ftpscript.txt www.ukdatait.co.uk

in the script file is the following minus the user name and password for
obivious reasons......

username
password
cd /web/protected/cgi-bin/ppFolder
put sgard.zip
quit

but if i run this manually, no problems the file is put onto the ftp site.
but i am after this as part of the automation process. can anybody help?

Many thanks
Simon Whale





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.