SQL Server Performance

3 results from a DTS

Discussion in 'SQL Server DTS-Related Questions' started by levogiro, May 12, 2006.

  1. levogiro New Member


    i'd like to know how do i manage this 3 situations:

    - if my TXT file is found then execute the rest of the DTS;
    - if my TXT file is not found, but the time limit is not reached
    then is doesn't do anything;
    - if my TXT file is not found and the time limit is reached
    then the DTS should return a failure.


    benedito r. almeida filho
  2. cmdr_skywalker New Member

    use vb script to return different result. set the value to the global variable.

    May the Almighty God bless us all!
  3. satya Moderator

    ... even you can use WORKFLOW to accomplish the task, refer to books online andhttp://www.sqldts.com for similar help.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page