<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Lanre Famuyide
»
Simple Steps to Creating SSIS Package...
25 posts, Page 2 of 3
««
1
2
3
»»
Simple Steps to Creating SSIS Package Configuration File
Rate Topic
Display Mode
Topic Options
Author
Message
zeetechie
zeetechie
Posted Thursday, May 14, 2009 12:54 PM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, February 14, 2013 6:43 PM
Points: 4,
Visits: 36
I'm currently using a SQL server table to store the SSIS configuration settings for my packages. I haven't played with the XML option, but find it interesting. Could someone comment on some of the practical applications of using the XML configuration file approach instead of using a SQL server table?
EDIT: and what I mean is what the advantages of using XML config files that could not be done or be done better vs. using the SQL server table approach, in real world application.
Thanks!
Post #717288
R_Casey
R_Casey
Posted Thursday, May 14, 2009 2:14 PM
Grasshopper
Group: General Forum Members
Last Login: Monday, April 01, 2013 8:50 AM
Points: 15,
Visits: 66
I have just completed DTS to SSIS conversion and the XML config file worked great for my application. It made deployment much easier that before.
Post #717372
rubinov
rubinov
Posted Friday, May 15, 2009 2:42 PM
Forum Newbie
Group: General Forum Members
Last Login: Friday, March 08, 2013 6:20 AM
Points: 1,
Visits: 15
I used to create packages as files on disk. And after development is completed I copy them to appropriate production directory.
When creating configuration file (CF below) the only option I see is to set package CF with particular path_name.
Is it possible to have package understand to work with CF located in the very same directory (along with package file) no matter what path was documented for CF?
Or is it possible to change configuration file path without rebuilding the package?
Thanks
Yuri Rubinov
Post #718304
Famson
Famson
Posted Friday, May 15, 2009 3:07 PM
SSC Rookie
Group: General Forum Members
Last Login: Friday, January 18, 2013 2:00 PM
Points: 35,
Visits: 163
You can place the package configuration file in any location. What is important is for you to select the appropriate configuration file during deployment and to ensure the file can be read.
Should the path of the configuration file be changed, then the package should be re-deployed using the configuration file in the new path.
Post #718326
David Betteridge
David Betteridge
Posted Friday, May 15, 2009 4:56 PM
Right there with Babe
Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:41 AM
Points: 739,
Visits: 1,565
I think I read some where that after adding a new environment variable that you have to reboot. Is that true?
Post #718383
Famson
Famson
Posted Saturday, May 16, 2009 11:42 AM
SSC Rookie
Group: General Forum Members
Last Login: Friday, January 18, 2013 2:00 PM
Points: 35,
Visits: 163
David, if you create a new system environment variable, you may have to restart the system, but for a user environment variable, you may have to log off and log on again.
Cheers!
Post #718546
Mathew Michuta
Mathew Michuta
Posted Saturday, May 16, 2009 2:13 PM
SSC Rookie
Group: General Forum Members
Last Login: Tuesday, February 12, 2013 9:20 AM
Points: 30,
Visits: 100
I personally LOVE using the XML format. One thing that I found cumbersome however, is viewing the XML. If you right click on the .dtsConfig file, choose to open it in Visual Studio Version selector, it gives you one looooong XML string.
Hold Ctrl, press K, then D, and VS auto formats the XML for you. This has saved countless hours of reformatting.
This small nicety makes a world of difference, and old developer friend of mine showed me that trick.
Post #718554
mishaluba
mishaluba
Posted Sunday, May 17, 2009 4:40 PM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 5:54 PM
Points: 525,
Visits: 617
Thank you for the article and thank you to Mathew for the trick with Visual Studio shortcut. Very useful!
Post #718751
Lempster
Lempster
Posted Monday, May 18, 2009 8:08 AM
UDP Broadcaster
Group: General Forum Members
Last Login: 2 days ago @ 7:39 AM
Points: 1,448,
Visits: 755
zanoni.harris (5/14/2009)
Could someone comment on some of the practical applications of using the XML configuration file approach instead of using a SQL server table?
...what I mean is what the advantages of using XML config files that could not be done or be done better vs. using the SQL server table approach, in real world application.
Like a previous poster I use an Environment Variable as the 'parent' package configuration which contains the details of the SQL Server database table in which the 'child' package configurations are stored.
The only advantage I can think of for the XML file approach is that it is more intuitive, i.e. you can see immediately what values you are setting for the variables/connection strings within your package rather than having to ascertain the location/name of table and then query that table.
The big disadvantage is security; by storing the configuration details in a table you can set very granular permissions to that table - important if the table holds connection strings to production environments.
Regards
Lempster
Post #719086
zeetechie
zeetechie
Posted Monday, May 18, 2009 8:47 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, February 14, 2013 6:43 PM
Points: 4,
Visits: 36
Great, thanks for the info Lempster. Also, great tip with the VS and viewing XML files Mathew.
Best,
Z
Post #719134
« Prev Topic
|
Next Topic »
25 posts, Page 2 of 3
««
1
2
3
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
