?
Solved

execute SSIS package (using DTEXEC utility) programmatically

Posted on 2010-08-25
5
Medium Priority
?
2,516 Views
Last Modified: 2013-11-30
Hi, can I have some sample code to execute a SSIS package (stored on the file system, not in database) using DTEXEC utility programmatically using C# OR VB.NET and also some sample code to kill that process if runs unexpectedly for a long time?. thanks in advance.  I will also need to specify the log file path and capture the result (success, failed or cancelled).
0
Comment
Question by:rkpavp
  • 3
4 Comments
 
LVL 9

Expert Comment

by:puru1981
ID: 33521857
please look at this article. Might help you

http://www.mssqltips.com/tip.asp?tip=1775
0
 
LVL 9

Expert Comment

by:puru1981
ID: 33521885
this is how you can do it programmatically

http://msdn.microsoft.com/en-us/library/ms136090.aspx
0
 

Author Comment

by:rkpavp
ID: 33522780
I have seen those articles already. I am specifically looking for code that uses DTEXEC to execute a package. according to this link http://blogs.msdn.com/b/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx, using SSIS object model may recycle webserver application pool, so I am looking to use DTEXEC. I know how to use DTEXEC from command line, but looking for sample to execute the same from C# code. thanks.
0
 
LVL 9

Accepted Solution

by:
puru1981 earned 2000 total points
ID: 33523523
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

598 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