sql server dts: Hi,



Could someone explain me the difference between calling the execute method
of a DTSStep_DTSActiveScriptTask and setting its execution status to
DTSStepExecStat_Waiting?



Thanks



--Ilann

Hello Ilann,

The first says to fire the step. I have never had to explicitly call this
method although I have seen others ask for this. The second basically tells
the package that this step still has work to do and it is waiting to do it.
A popular implementation of this is when you want to perform loops.

Here is an example

Looping, Importing and Archiving
(http://www.sqldts.com/default.aspx?246)


Allan


[quoted text, click to view]