Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1260
  • Last Modified:

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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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