Solved

execute SSIS package (using DTEXEC utility) programmatically

Posted on 2010-08-25
5
2,359 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 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 500 total points
ID: 33523523
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

752 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