Very Computer

1. Error executing a DTS package from another DTS package

I'm trying to execute one package from another using the following ActiveX
script code:

Function Main()

Dim oPkq

Set oPkq = CreateObject("DTS.Package")

oPkq.LoadFromSQLServer "Server","myuser","mypass",,,,,"Old HBdb to New HBdb
for 4 Tables"

'oPkg.GlobalVariables("DatabaseName").Value = "mssdet"

MsgBox oPkg.Name

oPkg.Execute

Set oPkg = Nothing

Main = DTSTaskExecResult_Success

End Function

I get an error at line (MsgBox oPkg.Name) on SQL 2000:

VBS Runtime Error 0

Object required 'oPkg'

Any ideas on what is wrong?

Thanks!

2. Printer paper size problems

3. Capture Error in DTS Package, From Inside DTS Package

4. activeX controlts

5. Gracefully aborting a DTS Package

6. Enter Mariah Vision 3Scape contest

7. Scheduling DTS package causes the job to abort

8. Case insensitive queries in D3

9. Gracefully aborting a DTS Package

10. Abort execution of a DTS package

11. DTS Aborts on package start

12. Aborting DTS package in mult-threaded .NET app

13. Aborting execution of DTS package