Hi...

I'm writing a DTS that before running, it's crucial that one variable
is changed. To remind me (or whoever) to change this variable, I'd
like to write a ActiveX script to simply say something like "Did you
change the Month Code Variable" [Yes] [No]. If they click Yes, it
contiues and runs the script.. but if No, it fails and ends the DTS.

I know little to nothing about ActiveX, so I'm not sure how to do
this. I already have a starting SQL Task that begins my DTS, so I'm
hoping to place this Confirmation ActiveX script before that and only
on Success it will continue to the SQL Task.

Is this possible? I assume so, but I can't find any documentation on
how to do it.

Thanks,

Alex.

At the start of you package you do this in an Active Script task


Function Main()



if MsgBox( "Did you change the Vals", vbYesNo ,"Change" ) = vbYes then
'Continue
msgbox "Continue"
else
'Stop
msgbox "Stop"
end if

Main = DTSTaskExecResult_Success
End Function


Instead of saying "Continue" or "Stop" you add workflow that either exits
the package or carries on

Multiple Paths in Workflow
(http://www.sqldts.com/default.aspx?218)


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


Make sure this package is not scheduled though.


--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Alex" <alex (AT) totallynerd (DOT) com> wrote