SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Events
Classes
About Us
Login / Register
Subscribe RSS Feed 

Confio Ignite

SSIS Configurations

In this session, Brian shows you how to use configuration files or a configuration file to dynamically configure your packages. With configuration files, you can seamlessly migrate an SSIS package from QA to production without worry and without having to reconfigure the package.

Duration:
11 mins 49 secs
Skill Level:
300
Rating:
4.36 out of 5
Publish Date:
May 02, 2007
SSIS Configurations You must be logged in to view this video.  
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Brian Knight
Owner of Pragmatic Works :: Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of Jumpstart TV and SQLServerCentral.com. Brian has written and co-written 9 technical books. Brian has spoken at conferences like PASS, TechEd and Connections. Brian develops solutions with Pragmatic Works to migrate DTS packages to SSIS.

References




Comments
Romar on 9/8/2008
Very usefull and clear, although it took some effort o make the script task.

Ricardo on 9/10/2008
Can't see the video on Flash player 9.0

Indraneel on 9/22/2008
I am not able to see the video

Indraneel on 9/22/2008
which version of flash is required for this.

Larry Ansley on 9/23/2008
A quick easy to understand explanation just when I needed it. Thanks.

Sonny Burgess on 10/29/2008
Would like to see child package getting configuration values from parent.

Sanjay on 12/2/2008
great

HARSH KUMAR on 12/14/2008
really good.

HARSH KUMAR on 12/14/2008
really good.

HARSH KUMAR on 12/14/2008
really good

Amarnath on 12/29/2008
Crisp and clean..

Venkata Taduri on 2/19/2009
I liked the demo. Thank you.

John Ward on 2/25/2009
Just what I needed!

Phil Rothenberg on 3/9/2009
I would have liked to have seen more about using environment variables to point to the location of the config files. What happens if you have multiple config files in the same folder and you select the option to use the environment variable for the location? Which config file(s) does the package use?

Jeremy Pryor on 4/30/2009
Brian is an excellent presenter. This was short but packed with the exact information I needed. That is a perfect combination for me. Thanks!

Martin on 5/1/2009
Very good !

prashant on 5/7/2009
Good one brian

Michael on 5/14/2009
Liked the video, would've been useful to see the configuration file deployed and used in a mock production environment like scenario.

Rob Long on 5/29/2009
Very useful. Glad I found it.

Julie Moseley on 6/3/2009
as usual brian save my butt again!

John R deCoville on 6/16/2009
The "Snippet" is a little too Snippy to get a good view of the huge terrain that is SSIS

Dwight Barker on 7/8/2009
I am surprised that an end user would need to go in and modify an XML configuration file. Is there really not a friendly tool for that purpose?

Abhishek on 9/2/2009
Too Good....Voice was Clear this time.....Vedio was Clear.

Harit Kalathia on 9/21/2009
It is an excellent video, it would have been better if deployment with configuration file was included too.

logesh on 9/28/2009
I have enabled package configuration for the set of properties that I have identified now and has been used by many developers across packages. In future, if I have to add few more new variables that I would want to reflect in all the packages. How do I do that? Is Package Configuration the right option?

Guillaume Chauvat on 10/16/2009
The video doesn't show how to migrate from a development environment to a production one, keeping dev config in dev, and prod config in prod.

yaniv on 11/8/2009
too fast, good stf

Cole Knight on 12/3/2009
As always, excellent job.

Richard H. Lang II on 1/14/2010
Brian, These videos are great! They complement/augment/refresh the end to end training class in awesome fashion. I'm building an SSIS package that I need to test on a different server before I move it to production and I remembered from class that the connections could be handled dynamically, just couldn't remember exactly how. A simple 12 minute video and voila'. Thanks very much.

Leon on 1/27/2010
To the point and educational.

nick on 2/7/2010
that was coool.

Paul Yates on 3/2/2010
fantastic... you deserve a knighthood

pallavi on 3/23/2010
Very Good Presentation...really helpful

Wayne Motley on 4/26/2010
Good Demo

Sushmita on 5/1/2010
It helped me alot. Thanks Brian

Seema on 5/9/2010
Great presentation! Very helpful!

Maria on 6/1/2010
I'm just a beginner, so it's really useful for me

Anuja on 8/3/2010
great video. Do you have confirguration video for SQL server configuration. If you have then can you please post it

Don Gilman on 8/20/2010
Good volume, in depth. Might have shown it from two examples decomposing down instead of building up. Last bit about the re-use requires that I re-watch it a few times ;)

Don Gilman on 8/20/2010
Last bit about re-use or overwrite of the configuration file is confusing, went too fast on that section. Rest was quite educational.

MohanD on 10/21/2010
Good

xofuoy on 3/16/2011
The first part was good

Chris on 3/23/2011
Whats the rush Brian? A tad slower and it would be beautiful!

Robert McCormick on 3/23/2011
I like BK's videos. Always get something out of them. I'd like to see more detail on SQL Configurations with regards to moving a package from local to dev or dev to prod. Also would like to see one on parent package variable configurations

Stephen Schneider on 3/23/2011
Brian, Thanks for making this available. I forward this to recalcitrant developers as further motivation of how to do things right.

Wesley on 3/23/2011
Definely good for basics. Would like to see for more advanced configurations. Possible examples of Parent to child configurations.

nikhil on 3/23/2011
great.

Jason Yousef on 3/23/2011
Thanks!

Ameena on 3/23/2011
This was great presentation. I wish you had gone little slower. Never mind I can always re-watch this video. Thanks

Robert Djabarov on 3/23/2011
need to show more specific placement of missing config values in the progress dialog.

Didier I. on 3/23/2011
Very good presentation

Ken Davis on 3/25/2011
Even though Brian recorded this 4 years ago, the email arrived on the day I needed to set up an SSIS configuration file for the first time! Thanks very much!

Maurice Ivory on 3/28/2011
This was a really nice one.

venkatasuresh on 4/4/2011
Good

Katerina on 4/18/2011
It was very useful for me but like in many videos of this author, example that he tries to present as a prove of what he shows do not work.

Abdul on 7/12/2011
good

vishal on 7/26/2011
awesome

Doug on 10/20/2011
no one has yet to show this method work by deploying it to another environment and then showing the actual result in the new environment. So we're missing the deployment with the logic in place. One question I have is, when you deploy the package, does the xml configuration file populate the package store with the values in that configuration file (e.g. local)?

info on 1/22/2012
cool

shaik on 3/22/2012
nice demo

dip on 4/9/2012
Nice.

satish on 4/18/2012
Thank you



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions