Hi to everybody

Does anybody know how can I bypass an Execute SQL Task in a DTS
Workflow?
The bypass must be decided by the user in every execution.
I've designed the following workflow:

[ExecuteSQLTask]
[tasks]-[ActiveX Task For Path Decision] / \[Data
\ ----------------- /

Transformation Task]


Unfortunately it fails on the last Data Transformation Task because of
precedence constraints (can't make complex precedence constraints in
the Designer).

The ActiveX Task For Path Decision is something like this:

Dim sMsg, lResult
sMsg = "Do you want to branch Execution?" & vbCrLf & _
"Yes" & vbCrLf & _
"No"
lResult = MsgBox(sMsg, vbYesNo)

If lResult = vbYes Then
DTSGlobalVariables("Branch_1").Value = True
Else
DTSGlobalVariables("Branch_1").Value = False
End If

If (DTSGlobalVariables("Branch_1").Value = True) Then
Main = DTSTaskExecResult_Success
Else
Main =DTSTaskExecResult_Failure
End If


Any help will be wellcomed

Greetings,
David Grant

Hi,
"<icebold54 (AT) hotmail (DOT) com" wrote:
http://www.sqldts.com/default.aspx?214

Helge

Thank you for the link Helge, this has solved my issue.