execute SSIS package (using DTEXEC utility) programmatically

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).
rkpavpAsked:
Who is Participating?
 
puru1981Commented:
please look at this article. Might help you

http://www.mssqltips.com/tip.asp?tip=1775
0
 
puru1981Commented:
this is how you can do it programmatically

http://msdn.microsoft.com/en-us/library/ms136090.aspx
0
 
rkpavpAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.