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!
www.empoweredinformation.com

… 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.

]]>