flow in dts sql task

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: dk (anonymous_at_discussions.microsoft.com)
Date: 06/21/04 

Date: Mon, 21 Jun 2004 07:09:58 -0700

in a sql step of a dts package the code is
checking the count of a table.
if the count is greater than 0 i'd like
the success part to execute,
otherwise the failure part to execute.

is there a way to have the flow go to
a different task based on this conditional
sql code with dts?

tia,
dk

Relevant Pages

  • Re: Help with dtsrun and dts package.
    ... I dropped the tables from the database and that took care of the table ... The SQL server 2000 being used to create the dts package is on a different ... the MSDE master database but the message is that you cannot restore a SQL ... Can I create a dts package without using SQL 2000 Enterprise manager? ...
    (microsoft.public.sqlserver.odbc)
  • Priviledges problem with "execute master..xp_logevent&q
    ... Here is what I experienced when trying to get the logging into SQL ... If I execute the DTS package from Enterprise Manager using a SQL ... If I create a SQL job from the DTS package and run that sql job using ...
    (microsoft.public.sqlserver.dts)
  • Re: Job Scheduler fails and Managing Tempdb
    ... You can turn logging on on both the job and the DTS Package to get some more ... As I said in my previous post, shrinking tempdb is not very useful. ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • DTS Package - Destination Server is now off of domain.
    ... The SQL Services were previously running as ... Now, my DTS package fails. ... - drop database DATABASENAME. ...
    (microsoft.public.sqlserver.dts)
  • DTS Package - Destination server is now off domain.
    ... The SQL Services were previously running as ... Now, my DTS package fails. ... - drop database DATABASENAME. ...
    (microsoft.public.sqlserver.security)