SolvedPrivate

Execute C# exe program from ssis packages through sql 2012 agent job

Posted on 2014-07-17
6
21 Views
Last Modified: 2016-02-11
I have a SSIS package which calls Exe when I run the package from Microsoft visual studio the package runs fine but when I run the package from sql server agent job I'm getting error

     To run a SSIS package outside of SQL Server Data Tools you must install Execute C#
0
Comment
Question by:Bharat Guru
  • 3
  • 2
6 Comments
 

Expert Comment

by:Akhil vangala
ID: 40203011
The only difference is when you running it is using integrated windows authentication SSPI , when you running under the agent it might be using the agent service account which might not have the previllges it needs to run the exe

Agent job security
Grant agent service account required privilleges to run the exe or create a proxy account

let me know if you need help to create the proxy account
0
 

Author Comment

by:Bharat Guru
ID: 40203181
how can I check the Grant agent service account has the permission to run exe or not?
0
 

Author Comment

by:Bharat Guru
ID: 40203212
Agent service account has the privilleges to run the exe because when I try to run the exe by it self with out SSIS pachage  from sql server agent where job type = "Operation System (CmdExec)"  then exe successfully executed.
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Accepted Solution

by:
Akhil vangala earned 385 total points
ID: 40212794
What task are you using in ssis (execute process task) ? does your exe return a return code when it is success

If you are using process task make sure you set the proper working directory
0
 

Author Closing Comment

by:Bharat Guru
ID: 40215350
Thanks, It worked after I installed integration service
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 40215837
Thanks, It worked after I installed integration service
Which is exactly what I told you in your previous duplicate question here:
http://www.experts-exchange.com/Database/MS-SQL-Server/Q_28477152.html
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Viewers will learn how the fundamental information of how to create a table.
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.

867 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

12 Experts available now in Live!

Get 1:1 Help Now