config file

Last post 09-08-2008 5:28 AM by satya. 1 replies.
Page 1 of 1 (2 items)
Active Topics My Discussions Unanswered Sort Posts: Previous Next

  • 09-05-2008 4:10 AM

    config file

    Reply Contact

    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

  • 09-08-2008 5:28 AM In reply to

    • satya
    • Top 10 Contributor
    • Joined on 11-05-2002
    • United Kingdom
    • Posts 22,515
    • Microsoft MVP
      Moderator

    Re: config file

    Reply Contact

    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.

    -Satya S K J

    SQL Server MVP



    Knowledge is Power, you will gain by sharing it. SSQA.net - Invisible contributions to the users & visible success in SQL Community.
Page 1 of 1 (2 items)
Active Topics   My Discussions    Unanswered Posts


© 2000 - 2007 vDerivatives Limited All Rights Reserved.