• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1158
  • Last Modified:

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?
0
svs1919
Asked:
svs1919
  • 2
  • 2
1 Solution
 
HoggZillaCommented:
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now