Can VBScript call SQL Server DTS Packages???

[Guest_imported]

Hi,

I am trying to call DTS Packages within a case statement, however i am unable to find a solution to this problem. After appended a csv file i wish to load the file into a sql server table and then run a stored procedure. Once this has been commited i wish to loop around the same piece of code and run the script again. Finally once this has completed, do the next case statement.

 

[quatermass]

Hi,

I am more used to dealing with running DTS via batch files, but the following could be used to invoke a shell command to run the dtsrun.exe command

Dim WshShell
Set WshShell = WScript.CreateObject("WScript.Shell&quot
WshShell.run(dtsrun.exe command line)


There are probably better ways to execute this task, as I rarely use VBScript to control processing. A better way would be appreciated.


Kevin **************************************************************
Rock is Dead (Long Live Paper and Scissors)**************************************************************

 

[jonscott8]

Yes, DTS has a scriptable interface. See

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q252987

There's also a SQLS forum here where you could post if you need more. Jon Hawkins