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 |
|
Chinni
Yak Posting Veteran
95 Posts |
 Posted - 2008-09-25 : 16:12:00
|
| Can any one suggest meWhat needs to be taken care of when SSIS package is moved to production like congig file etc..Agent need to be set up for this package to run package every month.Any things need to be added to package,config file when moved to produciton/agent setup or when we hand over from development to production.please let me knowThanks |
|
|
clarkbaker1964
Constraint Violating Yak Guru
428 Posts |
Posted - 2008-09-26 : 00:18:12
|
Review the package and see if their is anything environment specific that is hardcoded into the package i.e. server names etc You can do anything at www.zombo.com |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-26 : 00:57:28
|
quote:
Originally posted by Chinni
Can any one suggest meWhat needs to be taken care of when SSIS package is moved to production like congig file etc..Agent need to be set up for this package to run package every month.Any things need to be added to package,config file when moved to produciton/agent setup or when we hand over from development to production.please let me knowThanks
you've added configuration settings in package to take the server and other connections correctly based on environment? You can used various methods for this. either use XML file or environment variable,...http://www.mssqltips.com/tip.asp?tip=1405 |
|
|
|
Chinni
Yak Posting Veteran
95 Posts |
Posted - 2008-09-26 : 10:48:23
|
| thanks a lot |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-26 : 10:49:38
|
quote:
Originally posted by Chinni
thanks a lot
Cheers  |
|
|
|
Chinni
Yak Posting Veteran
95 Posts |
Posted - 2008-09-26 : 12:26:08
|
| what need to be in config file.......connection manager and variables........i have a FTP task and i used a .bat file in that ..........should i add that path to config file............. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-26 : 12:35:21
|
quote:
Originally posted by Chinni
what need to be in config file.......connection manager and variables........i have a FTP task and i used a .bat file in that ..........should i add that path to config file.............
everything that changes while migrating from one environment to other needs to be included in config. |
|
|
|
Chinni
Yak Posting Veteran
95 Posts |
Posted - 2008-09-26 : 13:46:55
|
| what are .INI files....some packages use these.....thanksChinni |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-26 : 13:52:53
|
quote:
Originally posted by Chinni
what are .INI files....some packages use these.....thanksChinni
DTS packages used to make use INI files to get values for parameters. In SSIS, you can make use of package configuratin. EIther use XML file or environment variables for configuration setting.http://www.sqlis.com/26.aspx |
|
|
|
|
|
|
move SSIS package to production