Jumping all over the place

#1

Does anyone know how to set the next task in the pre-task-execute VBScript? That is, assume task1....task5. In task1, I check for a condition -- if that condition is TRUE, the next task should be task3, if it's false, the next task is task5. Does anyone know how to do that? Any help you could offer is greatly appreciated in advance, and I wont forget you when I write my will. Thanks!!!

#2

In article <D2EE69F2-1DD7-4BA3-8EE5-706D5CA6C844 (AT) microsoft (DOT) com>,
Casualinfoguy <anonymous (AT) discussions (DOT) microsoft.com> writes

Quote:

Does anyone know how to set the next task in the pre-task-execute
VBScript? That is, assume task1....task5. In task1, I check for a
condition -- if that condition is TRUE, the next task should be task3,
if it's false, the next task is task5. Does anyone know how to do that?
Any help you could offer is greatly appreciated in advance, and I wont
forget you when I write my will. Thanks!!!

This should explain the principles you need-

Skip the execution of an individual Task
(http://www.sqldts.com/default.aspx?214,1)
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Jumping all over the place

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Jumping all over the place - 12-17-2003 , 03:31 PM

Re: Jumping all over the place - 12-17-2003 , 04:27 PM