Run DTS from Exchange 2000

• scottsanpedro

  SSCrazy

  Points: 2130

  More actions

  September 8, 2005 at 10:12 am

  #165846

  Hello,

  Using SQL Server 2000

  Exchange 2000

  I'm looking for a solution to the following;

  When someone unsubscribes from our mailing list, we recieve an email in a specific folder. I want a stored procedure to be run with variable EMAIL ADDRESS passed. Therefore update our database to stop people receiving emails.

  Presumably I would need a script run that calls a stored proc in SQL Server

  OR

  Maybe a DTS package to be kicked into action

  Any ideas

  Thanks

  Scott

• andrewkane17

  SSCertifiable

  Points: 7529

  More actions

  September 8, 2005 at 10:52 am

  #588467

  have a look at http://www.informit.com/guides/content.asp?g=sqlserver&SeqNum=31

• scottsanpedro

  SSCrazy

  Points: 2130

  More actions

  September 13, 2005 at 9:21 am

  #589411

  This looks good. Thanks Andrew