SQL Server Performance Forum – Threads Archive
DTS Schedule Job failed
I have one DTS package with two ProcessTask, which execute two diffrent exe. When I am execute this package from DTS-> execute package than Its run fine, But when I try from schedule job It failed with error…CreateProcessTask ‘DTSTask_DTSCreateProcessTask_1’: Process returned code -55689741, which does not match the specified SuccessReturnCode of 0." Please help me, Its urgent… Thanks for your help in advance. Suneel
Check the SQL Agent permissions and check this as well
http://forums.databasejournal.com/archive/index.php/t-38505.html —————————————-
http://spaces.msn.com/members/dineshasanka
May also take help of KBAhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074 to schedule as a job. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Thanks for your response. I’ll check and let you know If It works fine.
quote:Originally posted by satya
May also take help of KBAhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074 to schedule as a job.
Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
.. and also make sure you’ve enabled the logging for DTS package to get step by step execution. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
It got solved. It was due to missing COM component. We re-installed it and now Its working fine.[<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]<br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by satya</i><br /><br />.. and also make sure you’ve enabled the logging for DTS package to get step by step execution.<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS†with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">
]]>