Conditionally executing DTS tasks?

#1

Hi group,

I need to skip certain tasks in a DTS package based on some condition (the
presence of certain rows in a database table). What would be the easiest
way to achieve this?
I'm not very familiar with VBScript, so I'd prefer a solution without
that...

Thanks in advance!
Jens

#2

Have a look at our articles here for examples of this

http://www.sqldts.com/default.aspx?103

Quote:

-----Original Message-----
Hi group,

I need to skip certain tasks in a DTS package based on
some condition (the
presence of certain rows in a database table). What would
be the easiest
way to achieve this?
I'm not very familiar with VBScript, so I'd prefer a
solution without
that...

Thanks in advance!
Jens
.

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

Conditionally executing DTS tasks?

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

Conditionally executing DTS tasks? - 09-24-2004 , 03:08 AM

Conditionally executing DTS tasks? - 09-24-2004 , 04:25 AM