Use an ExecuteSQL task to read the value of a SELECT COUNT(*) statement into
a Global Variable. In an Active X Script task check that Global Variable
and use Workflow to determine how you handle the package from there.
Multiple Paths in Workflow
(http://www.sqldts.com/default.aspx?218)
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"LIZ" <anonymous (AT) discussions (DOT) microsoft.com> wrote
Quote:
What the best object to use when need is to check if any rows exist on a
staging table and manipulate result? For example if rows exist I need to
|
perform a various of task otherwise do nothing. Thanks in advance.
DTS object to use -
12-11-2003
, 05:56 PM
Linear Mode
