how to prevent DTS to stop

• nelsonviggiani

  SSC Enthusiast

  Points: 171

  More actions

  December 14, 2007 at 10:54 am

  #70534

  Hello,

  I´m wondering if has any way to prevent the DTS to stop if it found an error. example

  I´m lookinf for some txt files, if it do not found file 1 send me an e-mail

  and go look for file 2 and forward...

  my dts as an activex to send e-mail in case of failure and after that I need it to keep going...and I don´t know how..

  any ideas??

  thanks

• Norman Kelm

  SSCommitted

  Points: 1922

  More actions

  December 14, 2007 at 11:10 am

  #760391

  This should get you started. Page 2 especially has the task enable/disable method.

  http://www.sqldts.com/218.aspx

  Norman

  DTS Package Search

  http://www.dtspackagesearch.com/