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 />
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.
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"
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.
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.
The account which i use to login is in groupsadministrators but not in useradministrator Thanks! "He laughs best who laughs last"
