Call DTS from VBS?

[thermidor]

Hi All,

I have a VBS program that creates a text file. After the file is created, I want to load some of the values from the file into SQL Server. Is the best way to do this to call DTS from VBS? If so, can anyone tell me how this can be accomplished/Point me to a tutorial on-line?
I know how to accomplish this with bcp but I feel like I should be doing it with DTS...

TIA,
Sven

 

[thermidor]

I found the answer and am posting it in case it might be of use to anyone else...

set objDTSPackage = CreateObject("DTS.Package")

objDTSPackage.LoadFromSQLServer "myDB", "sa", "", DTSSQLStgFlag_Default, "", "", "", "Test_Pkg"

objDTSPackage.Execute

Set objDTSPackage = Nothing

 

[balistikb]

where do you name the dts package to run?