i want to import a data from a view from database by DTS
how can i check that if the view is empty then i don't run rest of DTS .



thanks

Nick

Read the value of

SELECT COUNT(*) as RowsInView FROM VIEW into a Global Variable using an
ExecuteSQL task. In an Active Script task you can then test the variable's
value and either enable or disable the datapump.

Here are examples of using workflow like this

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


"nick" <fsheng (AT) ebreathe (DOT) co.nz> wrote