how to handle paths, connection info between dev,test,prod environments

• asita

  SSCarpal Tunnel

  Points: 4144

  More actions

  January 21, 2009 at 11:46 am

  #200318

  hello all

  can any one suggest any ideas for below issue

  i have to read data from file in one folder, then store it in database table

  for this i am specifsying the path for input folder and also specifying the database connection (DB name, table name)

  now i am done with my development

  in order to test it i have to move to test system(another system) in this source file is having different path than in devlopment system same way test Database

  how can i set it

  do i need to manually change it every time i move from dev to test & then Test to production ?

  am i correct please suggest me?

  or else any good idea to change these path & connection info without changing in package

  Thanks in advance

  asini

• Mukti

  SSCrazy

  Points: 2826

  More actions

  January 21, 2009 at 11:50 am

  #930593

  You need to create package configurations for this. If you are not familiar with the concept first go through http://msdn.microsoft.com/en-us/library/ms141682.aspx

  For setting up package configs follwoing article is a good start:

  http://www.sqlis.com/post/Easy-Package-Configuration.aspx