sql server dts: Question regarding disabling a task -- sql server dts

Question regarding disabling a task

Jeff
10/27/2004 2:38:47 PM

sql server dts:

I have been given the task of trying to correct some issues with some legacy
code and I have a question. Is it possible to disable a task using SQL.
For example, I have task A, B and C. Step A truncates a table, Step B
checks to see if the table is loadable (from a control table). If the table
is loadable, Step C is executedl...no problem. If the table is not
loadable, an error message of
loadable_flag_is_not_loadable_this_is_not_an_error' is raised. This failure
is preventing me from putting together a scheduled job. What I would like
to do is from Step B check and see if the table is loadable, if it is not
disable the following step. This would do 2 things, prevent Step B from
failing and would prevent the execution of Step C my goal.

Hopefully this makes sense,
Jeff

RE: Question regarding disabling a task

Yash
10/28/2004 4:19:06 AM

Visit

http://www.sqldts.com/

Yash

[quoted text, click to view]

Re: Question regarding disabling a task

Allan Mitchell
10/28/2004 7:54:10 PM

We have a few examples of doing exactly this in some of our other samples on
www.SQLDTS.com

A quick one is

Looping, Importing and Archiving
(http://www.sqldts.com/default.aspx?246)

There will be more reading in here

Workflow
(http://www.sqldts.com/default.aspx?103)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.