naren5star
asked on
SSIS with Execute Process task
I am running a package that has different kind of data flow tasks in it. I have execute process task control flow item. That executes an 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?
Also please note that,I have given a correct UNC path.
Also please note that,I have given a correct UNC path.
what error is it giving to you?
ASKER
Executed as user: MPFA\Cognizant. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 10:28:23 AM Error: 2011-09-06 10:29:07.23 Code: 0xC0029151 Source: Execute Process Task Execute Process Task Description: In Executing "\\mfa-srv-ab\d$\SSIS Sample\AutoEmailFax.exe" "" at "", The process exit code was "-532459699" while the expected was "0". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:28:23 AM Finished: 10:29:07 AM Elapsed: 43.992 seconds. The package execution failed. The step failed.
looks like a permission issue....
- Does the user running the job have the right to that package?
- did you setup the 'WorkingDirectory' for that Execute process task?
- Does the user running the job have the right to that package?
- did you setup the 'WorkingDirectory' for that Execute process task?
ASKER
Event I felt the same.I don't know how to check whether all required permissions are there?
(i.e.) How do I ensure that user running the job have all the sufficient rights?What are all the rights that a usee need to possess in order to run ?
I don't know,what you are referring to working directory for that Execute Process Task?Is that a property of an execute process task?If so, what value do i need to set that warking directory to?
(i.e.) How do I ensure that user running the job have all the sufficient rights?What are all the rights that a usee need to possess in order to run ?
I don't know,what you are referring to working directory for that Execute Process Task?Is that a property of an execute process task?If so, what value do i need to set that warking directory to?
yeah it's a property, and should probably be the directory where the exe is...
Also, did you try to delete that package and build a new one?
It seems sometimes SSIS packages fail when there was changes to DB (backup/restore, login changes, etc)...
Sorry I can't really help you more, I'm not an expert with SSIS problems...
Also, did you try to delete that package and build a new one?
It seems sometimes SSIS packages fail when there was changes to DB (backup/restore, login changes, etc)...
Sorry I can't really help you more, I'm not an expert with SSIS problems...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Please give proper permissions to Access that folder as well as executing permission of EXE to SQL Agent user.
ASKER
Thanks to all ..Especially many thanks to Jason for the link...
You're welcome, believe me all of us doing that mistake, we use an admin or SA account to devlop, then when we deploy we get permission denied!!
but always try to use package configurations to get out of that mistake.
but always try to use package configurations to get out of that mistake.