Set "LOCALHOST" as the SMTP server Name in SQL Server 2005 SSIS

• MSSQLBuddy

  SSCrazy

  Points: 2354

  More actions

  February 20, 2009 at 3:09 am

  #134927

  Hi All,

  I can receive my emails when i set the exact SMTP server name in SQL 2005 SSIS.

  The problem is that, I am done with almost 100 packages having SMTP server name with a common configuration in a root folder. Its too hard to find out the SMTP server names in each of the deployment servers. Previously in DTS packages, they had used common Database Mail Profiles, that has the SMTP server Name as the LOCALHOST.

  Is there any way, by which we can set the LOCALHOST as the SMTP server name in the SMTP package configuration too?

  Any help greatly appreciated.

  Thanks in advance,

  Priya

  Regards
  Priya