Welcome to PC Teach Me...

Free Computer Training Videos.

Although you do not need to register to access this site. Registering has its benefits. Such as:

  • Access to training material associated with the video you are watching [if applicable]
  • Automatic email updates when new training videos are available.
  • Ask for a training video.
  • Exclusive access to pose questions to me [limited availability as I am doing this for free :-)].
  • Free contribution of your own training topics, this includes referencing your videos outside of PC Teach Me.
  • Its Free!

Member Login

Lost your password?

Not a member yet? Sign Up!

By registering with this blog you are also agreeing to receive email notifications for new posts but you can unsubscribe at anytime.

25425 Registered Users
71 Number Of Articles
Free Video Tutorials (Email) Free Video Tutorials (RSS) Free Video Tutorials (Twitter) Free Video Tutorials (Flickr)

SSIS: Package Configurations

Part of Microsoft Integration Services

ssis SSIS: Package ConfigurationsSSIS: Setting up default values

One of the transitions from a beginner to an intermediate developer in SSIS is the ability to configure packages that you have created en mass. I.e. you have lots of packages but want a way to centralise administration.

Package Configurations In SSIS

This can be done in a variety of ways but the best way is by use of Package configurations, this area of SSIS is very easy to set up but requires some discipline from your part, as the old adage goes “too many eggs in one basket”, the same is true here.  Basically this file will potentially control all of your data sources so with one adjustment to ONE file you can alter potentially hundreds of packages, but at the same time one mistake can cause potentially hundreds of packages to fail.  So tread carefully!

With that discussed, this video will show you the basics and the rest is up to you!  Just like anything else in the BI workspace it’s an art form NOT an exacting science.  So please sit back and watch this video and do hope it helps all you budding SSIS people!

Other SSIS videos

This video is one of many SSIS tutorials on this site click here for more

Related Posts

585 Comments

  1. Kaelin358 says
    22 Mar 13 at 6:35am

    Excellent! very helpful!

  2. jamiebarrowtube says
    22 Jul 12 at 3:38am

    Glad I stumbled onto your videos when I was looking at learning SSIS, because not only are you clear but also show best practices like this one – keeping configuration separate. Nice job.

  3. 22 Jul 12 at 3:38am

    [..YouTube..] Glad I stumbled onto your videos when I was looking at learning SSIS, because not only are you clear but also show best practices like this one – keeping configuration separate. Nice job.

  4. MadMidgetPro says
    27 Apr 12 at 12:30am

    I am a database administrator. A developer in another department created a package for me to use in a job. Problem is it keeps failing. I tried changing the protection to dontsavesensitive and I use windows authentication. The package still fials. If I create this config file will it work or will the developer who created the package have to create this config file. I would love a solution I can implement instead of having to get the developer involved. Please help.

  5. 27 Apr 12 at 12:30am

    [..YouTube..] I am a database administrator. A developer in another department created a package for me to use in a job. Problem is it keeps failing. I tried changing the protection to dontsavesensitive and I use windows authentication. The package still fials. If I create this config file will it work or will the developer who created the package have to create this config file. I would love a solution I can implement instead of having to get the developer involved. Please help.

Leave a Comment

You must be logged in to post a comment.

Valid XHTML 1.0 Transitional website security