SQL Server Performance

Execute Process Task

Discussion in 'SQL Server DTS-Related Questions' started by Reddy, Feb 28, 2006.

  1. Reddy New Member

    I have a Execute Process Task in my DTS job, It gives the following error, how do i need to resolve it. pls HELP.<br /><br />Step Error Source: Microsoft Data Transformation Services (DTS) Package<br />Step Error Description:CreateProcessTask 'DTSTask_DTSCreateProcessTask_1': Process returned code 1, which does not match the specified SuccessReturnCode of 0.<br />Step Error code: 80040496<br />Step Error Help File<img src='/community/emoticons/emotion-7.gif' alt=':s' />qldts80.hlp<br />Step Error Help Context ID:4900<br /><br /><br /><br />Thanks!<br />"He laughs best who laughs last"<br /><br />
  2. satya Moderator

    http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=8950#39951 fyi.

    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.
  3. Reddy New Member

    I read that thresd before but didnt help. The problem is when run my move.bat file from DOS it works fine, it fails only when i run from a DTS. PLS HELP. its urgent.
    THanks

    Thanks!
    "He laughs best who laughs last"

  4. satya Moderator

    THen this could be problem with the command line usage from SQL, may check privileges for SQLAgent on the specified program & path.

    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.
  5. Reddy New Member

    where do u want me to check previlages, how to do it.

    Thanks!
    "He laughs best who laughs last"

  6. satya Moderator

    Check whether the account use to start SQLAgent is a part of local adminsitrators or any group that has write privilege to perform the task of that batch file.
    Start --> Control panel --< Administrative tools --> Computer administrator --> Local/User groups.

    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.
  7. Reddy New Member

    The account which i use to login is in groupsadministrators but not in useradministrator

    Thanks!
    "He laughs best who laughs last"

  8. cncncn New Member

    Enter the return code as 0 in the 'Execute process task'

Share This Page