SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Package configurations


Package configurations

Author
Message
sql_learner29
sql_learner29
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1323 Visits: 938
Package configurations
Hi all..

Can anyone tell me how to use package configurations..
can we use them also if the sql authentication is required to be changed where we deploy our packages..

I mean what is the use of having a congiguration file in our deplyment...
wat does it reain when we deploy ir?

Do we need to edit it after deployment?

how?


any help is appreciated.
Thanks


---------------------------------------------------

Thanks

Oracle_91
Oracle_91
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2120 Visits: 1742
Just go through the below link. Hope this would help you out.

http://www.sqlis.com/26.aspx
Greg Charles
Greg Charles
SSCrazy Eights
SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)SSCrazy Eights (8.5K reputation)

Group: General Forum Members
Points: 8531 Visits: 5980
You would have to edit the config file after creating it if you want to keep any connection passwords in it. Passwords aren't saved in the file, so you need to add them afterward.

Greg
pduplessis-723389
pduplessis-723389
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2369 Visits: 400
For me, package configurations all boil down to one thing - portability...

Basically if you have an environment where some level of change control is enforced, package configurations become sort of a not negotiable, wether you go for SQL or XML configurations.

Consider:
You are developing on your local C drive pointing to your local SQL server, or perhaps even a mapped network drive.
Now you need to deploy your package to a different machine where the job will be tested. For you to do this without package configurations, you would now have to manually go and update the package to point to the new drive letters.
After testing, your job needs to be productionalised. Once more you would need to change some settings to do this.

Why not simply have package configurations take care of all of this for you, have a configuration per environment. As an added bonus, once you have created a configuration, you can reuse it in multiple places provided you have the same naming conventions (which is a bonus as you now align to some kind of standard).

Some of the other benefits include for example when a setting changes. For example, what if a FTP site changes IP address? Are you going to go and change every package manually? Why not change it within your configuration and all your packages adjust automatically...

Good luck though, getting the understanding of Configurations going takes a while and a whole lot of discipline.

~PD
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search