Do I need cmd line access to run DTS from VB?

#1

If I want to run a DTS package from a VB.NET app. do I need
SQL Server command line capabilities?

My DBA, understandably so, does not want to give me xp_cmdshell.

TIA,
Marc Miller

#2

Not necessarily. You can use the DTS Object Model and call
whichever load method applies to your how you store your
package. You can find some examples at:
http://www.sqldev.net/dts/ExecutePackage.htm

-Sue

On Wed, 18 Jan 2006 14:37:36 -0500, "Marc Miller"
<mm1284 (AT) hotmail (DOT) com> wrote:

Quote:

If I want to run a DTS package from a VB.NET app. do I need
SQL Server command line capabilities?

My DBA, understandably so, does not want to give me xp_cmdshell.

TIA,
Marc Miller

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Do I need cmd line access to run DTS from VB?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Do I need cmd line access to run DTS from VB? - 01-18-2006 , 01:37 PM

Re: Do I need cmd line access to run DTS from VB? - 01-18-2006 , 02:21 PM