What I'm using:
MS Sql Server 7.0
DTS saved as local packages.
SQL Server enterprise Manager
The data resides on a dual processor nt server.
My question is when I execute my "lead" package from my computer(It controls the execution of my other packages via ActiveX Script Task.), does it go to the server to execute the "child" packages or does it execute them on my computer?
Dim objDTSPackage
Function Main()
Set objDTSPackage = CreateObject("DTS.Package")
objDTSPackage.LoadFromSQLServer "NTSERVER", , , DTSSQLStgFlag_UseTrustedConnection, , , , "My PAckage"
objDTSPackage.Execute
Set objDTSPackage = Nothing
Main = DTSTaskExecResult_Success
End Function