<div>
check the DTS Application section in the following link, very well explained<br />
<br />
<a href="http://www.codeproject.com/KB/vb/DTS__VBNET_.aspx" rel="ugc">http://www.codeproject.com/KB/vb/DTS__VBNET_.aspx</a>
</div>


<div>
Thanks. On this article; <a href="http://www.codeproject.com/KB/vb/DTS__VBNET_.aspx" rel="ugc">http://www.codeproject.com/KB/vb/DTS__VBNET_.aspx</a>&nbsp; &nbsp;I saw this yesterday but I cannot seem to reference the same Microsoft DTS Package object Library that they can using in their example with .net framework 2.0 ; I can reference DTS Runtime Wrap but the methods/objects appear to be different and I have been unsuccessful in figuring out the new syntax for 2.0
</div>


<div>
This works well but I'm not getting any feedback and I have to be able to tel lmy use that the package ran successfully &nbsp;<a href="http://www.sqlteam.com/item.asp?ItemID=19595" rel="ugc">http://www.sqlteam.com/item.asp?ItemID=19595</a> &nbsp;<br />
<br />
This works well also and produces output; anyway to capture that output into a database or text file so I can scan it for the word error/msg or is there a way to get it to return a value if it failed ?<br />
<br />
exec master..xp_cmdshell 'dtsrun /LOCAL /NPKG /E'<br />
Go<br />
<br />
exec doPublish<br />
<br />
Thanks for the great ideas from both experts.<br />

</div>


<div>
Actually: I think I found where I can output the xp_cmdshell; I'll explore further.
</div>


<div>
<div class="content wysiwyg-content">
Can anyone direct me to some sample code on how to run a DTS package from a Visual STudio 2005 VB.net application pass parameters to the DTS package ? &nbsp;I know the objects exist with <br />
Imports Microsoft.SqlServer.Dts<br />
<br />
but I have yet to figure out the correct property settings.<br />
<br />
I also tried DTS run with <br />
x = &quot;DTSRun.exe /S&quot; &amp;&nbsp;&quot;&quot;&quot;SERVER&quot;&quot;&quot; &amp;&nbsp;&quot; /N&quot; &amp;&nbsp;&quot;&quot;&quot;PACKAGE NAME &quot;&quot;&quot;&nbsp;&amp; &quot;&nbsp;/AgvCountry_Code=&quot; &amp;&nbsp;&quot;&quot;&quot;US&quot;&quot;&quot;<br />
with no luck.<br />
<br />
Thanks for any guidance.
</div>
</div>


Can anyone direct me to some sample code on how to run a DTS package from a Visual STudio 2005 VB.net application pass parameters to the DTS package ?  I know the objects exist with 
Imports Microsoft.SqlServer.Dts

but I have yet to figure out the correct property settings.

I also tried DTS run with 
x = "DTSRun.exe /S" & """SERVER""" & " /N" & """PACKAGE NAME """ & " /AgvCountry_Code=" & """US"""
with no luck.

Thanks for any guidance.

Run Existing DTS Package from VB.Net

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,