server recognition in DTS package

• Priya Shah

  Valued Member

  Points: 69

  More actions

  February 3, 2005 at 10:54 am

  #109687

  As in most organizations we have 3 DB environments: Dev, Test and production. Is there a way to use Dynamic properties in a DTS package that senses which server(

  Dev, Test or Production

  ) you are trying to run the DTS package and uses the approriate server and database? If this can be done it will reduce lot of maintenace to mirror the DTS packages in all 3 environments.

  Thanks in advance.

• grant marlow

  SSC Enthusiast

  Points: 199

  More actions

  February 4, 2005 at 7:26 am

  #540673

  Can you use '(local)' in the db connection so it always uses the local server?