Exiting a DTS Package if no rows exist in a given table.

#1

Does anyone know how you can exit a DTS package if no rows
exist within a given table?

Thanks

David.

#2

Thanks for help Allan.

Cheers

David.

Quote:

-----Original Message-----
Yes

You can

1. Use ADO in an ActiveScript task to find out how many
rows are in the
table and based on this determine whether to proceed.

Multiple Paths in Workflow
http://www.sqldts.com/default.aspx?6,103,218,7,1

2. Use an ExecuteSQL task to do SELECT COUNT(*) and
assign value to a
global variable. You then test the value of the global
variable and take
action as 1.

3. If you want to test the recordcount before you
DataPump the table then
simply carry on with the datapump and test in an ActiveS
Script task the
RowsComplete property of the datapump in an Active Script
task.

--

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
.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Exiting a DTS Package if no rows exist in a given table.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Exiting a DTS Package if no rows exist in a given table. - 08-22-2003 , 06:00 AM

Re: Exiting a DTS Package if no rows exist in a given table. - 08-22-2003 , 06:39 AM