How to -Check if file exists in folder +send it by mail +move

• midan1

  SSCertifiable

  Points: 5100

  More actions

  November 28, 2005 at 7:10 am

  #70027

  i am new with DTS

  need help

  how to do this all with  DTS ??

  1. Check if file exists in folder
  2. move the file to backup  folder
  3. save the file with uniq file name !!
  4. send it by mail  (with the new file name)
  5. evry 30 minute

  thnks

  ilan

• Jonathan Stokes

  SSCrazy Eights

  Points: 9861

  More actions

  November 28, 2005 at 9:46 am

  #606148

  For the files see:

  http://www.sqldts.com/default.aspx?292

  To send a mail use either the sendmail task in dts or xp_sendmail. Check BOL as there are plenty of examples of xp_sendmail

  ---

  ------------------------------
  The Users are always right - when I'm not wrong!