Overview of package:

SQLTASK1->DynamicPropertyTask->SQLConnection->TextFileConnection->SQLTASK2->SQLTask3->ActiveXTask


I have a table (Export) that consists of 1 column ExportID. The
package grabs the first ID in the table into a global variable. It
uses this value to grab the data in a corresponding table and then
export that data to a flat file. After the export has successfully
completed, the ID stored in the global variable is deleted from the
Export table. The next step in the package looks at the Export table
to see if another ID is waiting to be exported. If it is, the
ExportID global variable is reset to the new ID in the Export table.

This is where I am at a stand still...I would like to be able to call
the first step in my package to start the whole loop again if there is
a value in the ExportID global variable. If there is no value in the
export table, I would like the package to just finish.

Is there a way to simply call the SQLTask1 so that the process is
started again?

In message <fea127bc.0408180800.37c806a (AT) posting (DOT) google.com>, Matt Morgan
<mmorgan (AT) unitedequity (DOT) biz> writes

DTSGlobalVariables.Parent. _
Steps("SQLTASK1"). _
ExecutionStatus = DTSStepExecStat_Waiting

Several loop examples here-

Workflow
(http://www.sqldts.com/default.aspx?103)
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org