tripower (8/13/2010)
OK, I did that with a VB scrip message box that has an OK and Cancel button but how to I cancel execution of the package if the user clicks cancel.
You are mostly using SSIS like a front-end application though SSIS is designed for ETL and it should be used without any user intervention... How you are planning to execute this in production? Because once you schedule this job these warning message only appear in the system where you scheduled it.
Instead if the graph is only for one user and who is going to run this from his machine on demand then it should be fine.
Anyways, u can achieve that using something like below code...
Dim x As MsgBoxResult
x = MsgBox("test message", MsgBoxStyle.YesNo)
If x = MsgBoxResult.Yes Then
Dts.TaskResult = Dts.Results.Success
Else
Dts.TaskResult = Dts.Results.Failure
End If
[font="Arial"]BASKAR BV
http://geekswithblogs.net/baskibv/Default.aspx
In life, as in football, you won’t go far unless you know where the goalposts are.[/font]