A Component with a condition & then execute a Task

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

A Component with a condition & then execute a Task

Author

Topic

ismailc
Constraint Violating Yak Guru

290 Posts

Posted - 2007-09-11 : 09:16:56

Hi,

I am looking for A Conditional Component when true & then execute a Task
eg. IF = Y then execute task else not

I'm not to sure. Something like a

A Record in a query

DTS Task

DTS Parameter
Regards

Vinnie881
Master Smack Fu Yak Hacker

1231 Posts

Posted - 2007-09-11 : 10:19:46

I'm not sure what you are talking about exactly.

you can use "If" statments in T-sql


if (1=2)
Begin
select 'hello'
end
else
begin
select'something else
end

Is this what you are referring to? If not please elaborate.

ismailc
Constraint Violating Yak Guru

290 Posts

Posted - 2007-09-11 : 10:22:35

Hi, thanks for the reply.

We execute a list tasks (being DTS packages, SSIS, copying of ascii files to network) etc. one after another

The problem is that it's unstable were the task will execute based on a previous task that might have encounted errors so we only really notice once a user complains or on arrival in the mornings then it's to late.

The idea that we want to incorporate is like a checklist were it execute a job goes back to the checklist(?) sets it's flag or ? and then on true/flag execute the next task.

Regards

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources