dbTalk Databases Forums  

Execute Process task fails after package is saved

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


Discuss Execute Process task fails after package is saved in the microsoft.public.sqlserver.dts forum.



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

Default Execute Process task fails after package is saved - 06-02-2008 , 10:16 AM






Hi All



I have a DTS package which uses an "Execute Process Task" to run a BAT file
which is on the server's C:\.

What happens is I setup the task by browsing to the file. And then test it
by selecting "Execute Step". The execution succeeds every time I try it until
I save and close the package. As soon as I re-oopen the package and try to
execut the step again it returns:

"CreatePRocessTaks 'DTSTask_DTSCreatePRocessTask_2': Process returnd code 1,
which does not match the specified SuccessREturnCode of 0."



Any help would be much appreciated.




Reply With Quote
  #2  
Old   
jhofmeyr@googlemail.com
 
Posts: n/a

Default Re: Execute Process task fails after package is saved - 06-03-2008 , 04:24 AM






Hi Bouce,

Is that the only error message? Seems like it is trying to run, but
the BAT file isn't working ... usually when SSIS fails it produces a
number of error messages, and sometimes the one that is the actual
problem is not apparent

Good luck!
J

Reply With Quote
  #3  
Old   
jhofmeyr@googlemail.com
 
Posts: n/a

Default Re: Execute Process task fails after package is saved - 06-03-2008 , 04:24 AM



Hi Bouce,

Is that the only error message? Seems like it is trying to run, but
the BAT file isn't working ... usually when SSIS fails it produces a
number of error messages, and sometimes the one that is the actual
problem is not apparent

Good luck!
J

Reply With Quote
  #4  
Old   
jhofmeyr@googlemail.com
 
Posts: n/a

Default Re: Execute Process task fails after package is saved - 06-03-2008 , 04:24 AM



Hi Bouce,

Is that the only error message? Seems like it is trying to run, but
the BAT file isn't working ... usually when SSIS fails it produces a
number of error messages, and sometimes the one that is the actual
problem is not apparent

Good luck!
J

Reply With Quote
  #5  
Old   
jhofmeyr@googlemail.com
 
Posts: n/a

Default Re: Execute Process task fails after package is saved - 06-03-2008 , 04:24 AM



Hi Bouce,

Is that the only error message? Seems like it is trying to run, but
the BAT file isn't working ... usually when SSIS fails it produces a
number of error messages, and sometimes the one that is the actual
problem is not apparent

Good luck!
J

Reply With Quote
  #6  
Old   
jhofmeyr@googlemail.com
 
Posts: n/a

Default Re: Execute Process task fails after package is saved - 06-03-2008 , 04:24 AM



Hi Bouce,

Is that the only error message? Seems like it is trying to run, but
the BAT file isn't working ... usually when SSIS fails it produces a
number of error messages, and sometimes the one that is the actual
problem is not apparent

Good luck!
J

Reply With Quote
  #7  
Old   
jhofmeyr@googlemail.com
 
Posts: n/a

Default Re: Execute Process task fails after package is saved - 06-03-2008 , 04:24 AM



Hi Bouce,

Is that the only error message? Seems like it is trying to run, but
the BAT file isn't working ... usually when SSIS fails it produces a
number of error messages, and sometimes the one that is the actual
problem is not apparent

Good luck!
J

Reply With Quote
  #8  
Old   
jhofmeyr@googlemail.com
 
Posts: n/a

Default Re: Execute Process task fails after package is saved - 06-03-2008 , 04:24 AM



Hi Bouce,

Is that the only error message? Seems like it is trying to run, but
the BAT file isn't working ... usually when SSIS fails it produces a
number of error messages, and sometimes the one that is the actual
problem is not apparent

Good luck!
J

Reply With Quote
  #9  
Old   
jhofmeyr@googlemail.com
 
Posts: n/a

Default Re: Execute Process task fails after package is saved - 06-03-2008 , 04:24 AM



Hi Bouce,

Is that the only error message? Seems like it is trying to run, but
the BAT file isn't working ... usually when SSIS fails it produces a
number of error messages, and sometimes the one that is the actual
problem is not apparent

Good luck!
J

Reply With Quote
  #10  
Old   
Bouce
 
Posts: n/a

Default Re: Execute Process task fails after package is saved - 06-03-2008 , 08:20 AM



Hi J

Unfortunately that is the only error I see. I literally set the path,
successfully run the step. then sace and close my package and re-open just to
execute that step again and get this message... if I re-select the path
again it works again...

"jhofmeyr (AT) googlemail (DOT) com" wrote:

Quote:
Hi Bouce,

Is that the only error message? Seems like it is trying to run, but
the BAT file isn't working ... usually when SSIS fails it produces a
number of error messages, and sometimes the one that is the actual
problem is not apparent

Good luck!
J


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.