SSIS - Data Viewers
We are slowly getting there! Our packages are coming along quite nicely but then DISASTER! You are getting errors all of sudden. After you have ran around the office screaming for 5 minutes and grabbed a cup of coffee you need to tackle this head on!
Well take a deep breath and relax, because with the use of Data Viewers inside Microsoft Integration Services you can quickly pinpoint the pesky blighter. Finding the core problem is easy but fixing is something else! Data Viewers wont show you how to fix the error, but will help you identify the source of the problem. This rather unused option by newbies is the key to becoming a pro! Once you have mastered these wonderful tools it will make you life so much easier.
What do they do? Well, they simply display your data with the confines of SSIS. If your doing string manipulation you can literally see the result of your transformation prior to SSIS throwing its toys out the pram! But is doesnt just end there, if the data your importing/transforming is an unknown entity for your warehouse you can use Data Viewers to highlight trends in your data too! Thus identifying new look-up tables you may need to incorporate.
So they are more than just a debug tool, they can be used to help you sulpt your transformations as you go.
This video shows a full designed package which you can follow along. You will need to download the file from PCTeach.Me
In questa pagina del sito puoi guardare il video online SSIS - Data Viewers della durata di ore minuti seconda in buona qualità , che l'utente ha caricato PCTeachME 13 settembre 2010, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 4,905 volte e gli è piaciuto 11 spettatori. Buona visione!
