Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2011-10-24 : 06:43:29
|
| In Dev, Package1 has a config file for setting the variables, etc... This package works using a scheduled job in Dev... Now, I would like to move the package to Prod. How do I do this and what should be done to the config file in Prod? Thanks |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-10-24 : 07:04:32
|
| Copy the package file (dtsx) to the prod server.Copy the config file to the prod server and edit it for the production values.Now you have to make sure that the package picks up the config file. Make sure that the dev values are invalid in production so that the package errors if the values are not changed.I always log the values when the package starts so that they can be checked. Also I tend not to use config files but pass the settings in the package call to set variables.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-24 : 07:24:52
|
| are you using indirect configuration? else you might have to repoint the config file path if its different from dev path------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-10-24 : 09:15:29
|
quote:
Originally posted by visakh16
are you using indirect configuration? else you might have to repoint the config file path if its different from dev path------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
When adding the config file, I specify the path. This is in Dev.? |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-10-24 : 09:17:04
|
| Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2011-10-24 : 09:41:32
|
| Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-24 : 09:43:44
|
| wc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
package from Dev to Prod