Solved

How to run an .exe file in ssis

Posted on 2009-04-13
5
1,234 Views
Last Modified: 2013-11-10
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
Comment
Question by:svs1919
  • 2
  • 2
5 Comments
 
LVL 57

Expert Comment

by:Raja Jegan R
Comment Utility
0
 

Author Comment

by:svs1919
Comment Utility
where do i put this course in script task?
0
 

Author Comment

by:svs1919
Comment Utility
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
 
LVL 57

Expert Comment

by:Raja Jegan R
Comment Utility
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
 
LVL 17

Accepted Solution

by:
HoggZilla earned 500 total points
Comment Utility
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
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.
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…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

743 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

15 Experts available now in Live!

Get 1:1 Help Now