How to run an .exe file in ssis

i am using a execute process to run an .exefile. How can i run a .exe file with out using execute process task in ssis.
svs1919Asked:
Who is Participating?
 
HoggZillaConnect With a Mentor Commented:
You could call the executable from an Execute SQL Task using the xp_cmdshell stored procedure.
http://www.sqlservercentral.com/articles/Administration/xpcmdshell/141/ 
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
0
 
svs1919Author Commented:
where do i put this course in script task?
0
 
svs1919Author Commented:
i got thos code in internet but when i paste this code in script task its giving me an error. am i doing right
where do i specify my .exe file that has to run?
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime
 
System.Diagnostics.ProcessStartInfo startInfo = new System.Diagnostics.ProcessStartInfo(Setting.PostProcessor,commandLineArgs);
 
startInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Normal;
 
startInfo.WorkingDirectory = "C:\\Test"; 
 
startInfo.UseShellExecute = false;
 
System.Diagnostics.Process process = new System.Diagnostics.Process();
 
process.StartInfo = startInfo;
 
process.Start();

Open in new window

0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
I am not familiar with VB Code and hence request you to include VB.Net or more zones so that experts can help you out with the VB Script attached.
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.