Global variable results

#1

Hi

I have a SQL Task which simply selects a row from a table based on an input
parameter. The result of this is then assigned to a global varaiable.

How do I then run another task based on the result of the global variable
i.e. if variable has a value then run task else if 0 then skip to next
task.?

Also I will probably have around 30 or more bulk insert tasks, will this
have an adverse affect on performance if I have these all in the saem
apckage?

Thanks alot

#2

See
http://www.sqldts.com/default.aspx?214
or
http://msdn.microsoft.com/library/de...kflow_0793.htm

Francesco Anti

"gordo" <gordo (AT) mail (DOT) com> wrote

Quote:

Hi

I have a SQL Task which simply selects a row from a table based on an
input
parameter. The result of this is then assigned to a global varaiable.

How do I then run another task based on the result of the global variable
i.e. if variable has a value then run task else if 0 then skip to next
task.?

Also I will probably have around 30 or more bulk insert tasks, will this
have an adverse affect on performance if I have these all in the saem
apckage?

Thanks alot

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

Global variable results

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

Global variable results - 02-24-2005 , 01:50 PM

Re: Global variable results - 02-25-2005 , 08:59 AM