Two ways I can think of.

1)  Create a SQL job that executes your DTS package and start the job by executing the sp_start_job stored procedure:

EXEC msdb.dbo.sp_start_job @job_name = 'your job...

Are you expecting to open the DTS package after the job runs and see that the value of the Global Variable has been updated?  That's not going to happen. 

The value...

Do all of the files have the same layout?  If so, set up one data transformation task and disable it (right-click on transformation, select Workflow Properties, and click the "Disable...

If you really need to access final value of the the global variable from the child package, why not update a table as the last step of the child package...

You can only return the initial value of a global variable from a DTS package executed via an Execute Package Task.  In other words, if the value of the global...

Looks to me like oRS.MoveNext is being executed twice when you come to a file that doesn't exist.  Try this:

Dim oRS, oPkg, oConn, iLoop, fso

Set oRS = DTSGlobalVariables("Path").Value

Set oPkg =...

Are you using a data transformation task?  If so, have it write an exceptions file.  Open the transformation task, go to the Options tab, and enter a path in the...

If the send mail task can successfully send an email, it will return Success.  If the mail server is unavailable or you try to send mail from an account you...

You can do it by executing cmdshell commands in an ActiveX script task.

This code assumes you're using global variables to store the values necessary to perform this task.

Replace FTPSite with...

With SQL Server 2000, go to the Options tab of the transformation properties window and uncheck the "Use fast load" box.

He's what I do with DTS packages to deal with development/testing/production scenarios:

I have a .ini file in the same location (c:\ini\sqlvalues.ini) on all SQL servers and developer's machines.  The ini...

Right-click on an empty space of a DTS package and select Properties (or click the Package/Properties menu).  Go to the Global Variable tab, enter a variable name, and select it's...

Well, not exactly if executed from a DTS package.  It will return the name of the server of the connection object your Execute SQL task uses, which may or may...

The DTSRun command looks a bit off to me.  Try:

DTSRun /S "(local)" /N "Students" /V "{89E57000-B5D3-4D31-85B9-4F5FFC730756}" /L "C:\Temp\LOG_Students.txt" /A "active_term:8=200610" /W "-1" /E

Use the Outer Package global variable and make sure the global variable name you're using matches the global variable in the package you're executing exactly.