SQL Server Performance

config file

Discussion in 'SQL Server 2005 Integration Services' started by arkiboys, Sep 5, 2008.

  1. arkiboys Member

    Hi,
    I would like to put the ssis package from Dev to Prod environment.
    How should the config file be configured so that I do not have to change anything while going from Dev to Prod?
    At present in Dev, I have a path in the config file which looks at the database in Dev.
    I can change this to point to live when moving to production but is there an easier way so that I do not have to make any changes when going from Dev to Prod please?
    Thanks
  2. satya Moderator

    When you have change in the servernames where you want to deploy then only the way is to handle with modifying config file, so at this point of time you don't have any other otpion.

Share This Page