3 results from a DTS | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

3 results from a DTS

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
[email protected]
use vb script to return different result. set the value to the global variable. May the Almighty God bless us all!
… 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.