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
Nesta página do site você pode assistir ao vídeo on-line SSIS - Data Viewers duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário PCTeachME 13 Setembro 2010, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 4,905 vezes e gostou 11 espectadores. Boa visualização!
