Is there a way to execute a single DTS task using VBScript in SQL 2000?

TIA,
Alex

Look up using DTSRUN -in Books Online.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"Ur Pal Al" <alexdavis (AT) cybercom-intl (DOT) com> wrote

Hello Arnie,

That won't allow you to execute a single task contained within a package
from ActiveX Script

There are Execute methods on both the Task and the Step objects

The task one is really for internal use only as it sits underneath the Step
and not what you look at when you look at designer.

The Step method can be used this way I believe but again I think it should
be used only internally by the package.


Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Allan,
That did the trick!

Code snipplet:
Set oPkg = CreateObject("DTS.Package2")
oPkg.LoadFromSQLServer "(local)", , ,
DTSSQLStgFlag_UseTrustedConnection, , , , "Test DTS pkg"

For Each oStep in oPkg.Steps
If oStep.Description = "test task" Then
oStep.Execute
Exit For
End If
Next

oPkg.UnInitialize

Allan Mitchell wrote: