I have an Active X Script defined for a DTS... During the execution of this script, I want to execute some other DTS as a part of the execution. Is there any command to run some other existing DTS this way ? I need some help...

Sure.

You can use the DTS Object model inside an ActiveScript task and call the
other package

What about something like

Function Main()

Const DTSSQLStgFlag_UseTrustedConnection = 256
Main = DTSTaskExecResult_Success

Dim oPKG
Set oPKG = CreateObject("DTS.Package")
oPKG.LoadFromSQLServer ".", , , DTSSQLStgFlag_UseTrustedConnection,
, , , "PackageName"
oPKG.Execute

Dim oStep
For Each oStep In oPKG.Steps
If oStep.ExecutionResult = DTSStepExecResult_Failure Then
MsgBox oStep.Name & " Failed"
Main = DTSTaskExecResult_Failure
End If
Next
oPKG.Uninitialize()
Set oPKG = Nothing

End Function


--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Mali" <anonymous (AT) discussions (DOT) microsoft.com> wrote

there any command to run some other existing DTS this way ? I need some
help...