| 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. 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 setup 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 potentialy hundreds of packages, but at the same time one mistake can cause potentially hundresd 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 artform NOT an exacting science. So please sit back and watch this video and do hope it helps all you budding SSIS people! This is one of many videos which can be seen at PCTeach.me. Come join the gang! |
