Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

execute SSIS package (using DTEXEC utility) programmatically

Posted on 2010-08-25
5
Medium Priority
?
2,447 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 2000 total points
ID: 33523523
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
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.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

660 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