SSIS Package task error

Posted on 2009-02-13
Last Modified: 2013-11-10
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?
Question by:svs1919
    LVL 17

    Accepted Solution

    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.

    Author Comment

    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.
    LVL 17

    Expert Comment

    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..

    Author Comment

    the .exe file is on the same server and same machine

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now