Bandwidth Monitor
SQLDTS.comSQLIS.comSQLIS Wiki
Skip the execution of an individual Task
By Darren Green
Page 1 | Page 2 | Page 3

3 Our final task, is just that, something to skip to.

' Pkg 214 (SkipTask - 3)
Option Explicit

Function Main()
	MsgBox "This the Final Task"
	Main = DTSTaskExecResult_Success
End Function

When you execute this package, you can choose to skip the middle task or not, but regardless of your choice the final task will still execute. The download to accompany this article contains a complete sample package. The package has a password of "sqldts". This ensures it is compatible across all versions of SQL Server and all service packs levels.

Page 1 | Page 2 | Page 3