sql server dts:

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


[quoted text, click to view]
staging table and manipulate result? For example if rows exist I need to
perform a various of task otherwise do nothing. Thanks in advance.