How do I call an SSIS package from an external VBscript?

• Jane-448437

  SSC Rookie

  Points: 38

  More actions

  October 22, 2007 at 2:45 am

  #119020

  We are upgrading to SQL2005, which also means upgrading MIIS to run on SQL2005 rather than SQL2000. We use several DTS to prepare the data for delta runs, and these are called using vbscript and the 'run dts' command.

  What is the equivalent to 'run dts' for SSIS, does anyone know?

  Thanks

  Jane

• okhere

  SSC-Addicted

  Points: 433

  More actions

  October 22, 2007 at 3:18 am

  #744040

  Hi Jane,

  Can this help perhaps?

  Refer to the DTEXEC section at the bottom.

  Osama

• Jane-448437

  SSC Rookie

  Points: 38

  More actions

  October 22, 2007 at 3:23 am

  #744043

  Looks helpful, and more than I've managed while trawling Google.

  thanks

  Jane