SSIS Package task error

Hi I am running  a package that has  different kind of data flow tasks in it. Ihave execute process task control flow item. That executes an exe file. When we manually execute that eze file it goes to a particular site and extracts some data and puts in sql tables. That site has a username and password but the credentials part is taken care by exe file. Now when I run this package manually every thing works fine. But if I run this package using a job it gives me an error. Except this execute process task every thing else in this package run  when I run this package from sql job. What could be the reason for the failure of this particular task?
svs1919Asked:
Who is Participating?
 
HoggZillaConnect With a Mentor Commented:
95% chance the problem is related to permissions. Copy the error message and paste here. If running from SQL Server agent, get the job history.
0
 
svs1919Author Commented:
please look at the SQL Server agent job error history.
Executed as user: ABCT\sqladmsd.
 Microsoft (R) SQL Server Execute Package Utility
 Version 9.00.3042.00 for 32-bit  Copyright (C)
Microsoft Corp 1984-2005. All rights reserved.    
Started:  4:15:49 PM  Error: 2009-02-11 16:16:17.23    
 Code: 0xC0029151     Source:  ActKeys Execute Process Task    
 Description: In Executing "C:\ActKeys\xyz.exe" "" at "",
The process exit code was "-532459699" while the expected was "0".  
End Error  DTExec: The package execution returned DTSER_FAILURE (1).  
Started:  4:15:49 PM  Finished: 4:16:17 PM  Elapsed:  27.422 seconds.  
The package execution failed.  The step failed.
0
 
HoggZillaCommented:
When you run this on the server, as a job, is the .exe file on the server in the C:\ActKeys directory - or is that on a different machine. I always use fully qualified paths. \\server\directoyr..
0
 
svs1919Author Commented:
the .exe file is on the same server and same machine
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.