Hi:

I am trying to create a loop based on http://www.sqldts.com/?246 , as I
have done before.

My loop is getting to the "Loop Around" task, but just finishing there
and not going to the ActiveX Task at the beginning of the loop. I'm
tearing my hair out here, it is pretty basic and I am not sure why it
isn't working. Here is my task at the end of the loop's code:


Option Explicit

Function Main()
Dim BeginLoopTask
Dim pkg

set pkg = DTSGlobalVariables.Parent
set BeginLoopTask = pkg.Steps("DTSStep_DTSActiveScriptTask_2")

BeginLoopTask.ExecutionStatus = DTSStepExecStat_Waiting

Main = DTSTaskExecResult_Success

End Function


I put a msgbox in the begin loop task at the beginning to see if it is
stopping there (since it is hard to tell in the DTS execution window if
it got executed again), and it doesn't. I checked the task names are
correct, I checked that the first task hadn't been disabled in the
code.

I'm willing to send along my package to look at the rest of the code if
anyone is willing to help.

Thanks,
Kayda

Hello Kayda,

OK So on initial inspection there does not seem to be a right lot wrong in
the code.

I can look at the package if you want. Can you make sure I have a full repro
with steps please.

Allan

Thanks Allan. I have emailed you at your profile email.

Kayda

Hi Allan:

The email in your profile didn't work. How can I contact you to send
you the .dts?

Kayda

Hello kayda,

In my email for this NG remove no-spam


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com