How Can I Change the Can someone tell me a way to make a wholesale change of all of our dts packages to reflect the value of "0" instead of "-1" in the SaveMailInSentItemsFolder property value at one time

• hll

  SSC-Addicted

  Points: 470

  More actions

  March 3, 2005 at 4:08 pm

  #92614

   

  Can someone tell me a way to make a wholesale change of all of our dts packages to reflect the value of "0" instead of "-1" in the SaveMailInSentItemsFolder property value .

  Thanks, Lloyd Langford

   

  To keep DTS from saving the item to the Sent Items folder, every DTS Send Mail Task must be modified in every package to disable the option.

  1.  Open the package

  2.  Click Package...Disconnected Edit

  3.  Select the appropriate Send Mail Task from the list

  4.  Change the SaveMailInSentItemsFolder property value to "0"

  5.  Save the package

• Johan Bijnens

  SSC Guru

  Points: 135550

  More actions

  March 4, 2005 at 12:29 am

  #545390

  maybe http://www.sqldts.com contains a solution for you ?

  check out sqldmo ?

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me