how to run sql 2000 package from vb.net 2005

• Barkingdog

  SSCoach

  Points: 18670

  More actions

  December 15, 2005 at 10:19 pm

  #90174

  Does anyone know of/have a sample of how to run a sql 2005 DTS package from vb.net 2005? I'm not even sure which COM libraries to include as references in VB.NET.

   

  TIA,

  Bill

• aj-156165

  SSC Enthusiast

  Points: 180

  More actions

  December 16, 2005 at 11:54 pm

  #610205

  Hi,

  There would be different ways to call/run  a DTS from any front-end applicaiton. Below is the method that I normally apply:

  - Will create a SP to call/run DTS package and the SP will executed from front-end applicaiton:

  Below is the SP and you know how to call SP from an application.

  CREATE PROC dbo.runDTS

  AS

  exec master..xp_cmdshell 'dtsrun /S "servername" /U "userid" /P "pwd" /N "DTSpackage"'

  -- you can apply any error handler to ensure no error being reported.

  -- End of SP 

  Regard,

  Ahmed

   

  -