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 |
|
vijays3
Constraint Violating Yak Guru
354 Posts |
 Posted - 2009-12-20 : 06:50:51
|
hi all,I have question regarding package congiguration file..If i create ssis package on my machine along with package configurationfile.But my problem is that,if i deploy this ssis package on other machine do i need to keep the configuration file at the particular location or does this file also require on that machine?Few points which i know about package configuration files are:1.we can contain the all information about package.2.we can chage the settings of the packge using the file without interfering to package on one machine.but my doubt is how this package file helps us on other machine if we deploy a package..can someone clear this points to meCheersvijay |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-12-20 : 09:11:24
|
What I know is:To deploy a package you have to copy - package file- manifest file- config fileto destination machine.When executing the manifest the setup gives the ability to change settings that come along with config file.That's it.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
vijays3
Constraint Violating Yak Guru
354 Posts |
Posted - 2009-12-20 : 09:49:38
|
| Hi Thanks for reply,I understand to manifest file and config file(Package configuration file),but what is the package file..As you mentioned the config file .Is it the same package configuration file or something else?help me to understand cheersvijay |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-12-20 : 09:53:41
|
The build process writes all needed files in a special output folder I remember...The package file is the .dts (or was it .dtsx?).The config file is that package configuration file with that name you have given while activating it in visual studio.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
vijays3
Constraint Violating Yak Guru
354 Posts |
Posted - 2009-12-20 : 10:15:13
|
| Thank you very muchNow this clear to me |
|
|
|
behrman
Yak Posting Veteran
76 Posts |
|
|
|
|
|
How do we use package configuration file