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

    hi,

    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.

    thanks,



    benedito r. almeida filho
    benedito.reynald@movecrm.com.br
    levogiro, May 12, 2006
    #2

  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!
    www.empoweredinformation.com
    cmdr_skywalker, May 12, 2006
    #2

  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
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, May 14, 2006
    #2

Share This Page