<div>
please look at this article. Might help you<br />
<br />
<a href="http://www.mssqltips.com/tip.asp?tip=1775" rel="ugc">http://www.mssqltips.com/tip.asp?tip=1775</a>
</div>


please look at this article. Might help you

http://www.mssqltips.com/tip.asp?tip=1775 [http://www.mssqltips.com/tip.asp?tip=1775]

<div>
this is how you can do it programmatically<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/ms136090.aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/ms136090.aspx</a>
</div>


this is how you can do it programmatically

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

<div>
I have seen those articles already. I am specifically looking for code that uses DTEXEC to execute a package. according to this link <a href="http://blogs.msdn.com/b/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx" rel="ugc">http://blogs.msdn.com/b/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx</a>, 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.
</div>


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 [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.

<div>
<div class="content wysiwyg-content">
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. &nbsp;I will also need to specify the log file path and capture the result (success, failed or cancelled).
</div>
</div>


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).

execute SSIS package (using DTEXEC utility) programmatically

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,