ToolShed Tooltip #20 - SSIS Data Profiling saves your eyeballs

Download

How do I download the videos?

• To download, right click the file type you would like and pick “Save target as…” or “Save link as…”

Why should I download videos from Channel9?

• It's an easy way to save the videos you like locally.
• You can save the videos in order to watch them offline.
• If all you want is to hear the audio, you can download the MP3!

Which version should I choose?

• If you want to view the video on your PC, Xbox or Media Center, download the High Quality WMV file (this is the highest quality version we have available).
• If you'd like a lower bitrate version, to reduce the download time or cost, then choose the Medium Quality WMV file.
• If you have a Zune, WP7, iPhone, iPad, or iPod device, choose the low or medium MP4 file.
• If you just want to hear the audio of the video, choose the MP3 file.

Right click “Save as…”

• WMV (WMV Video)
• MP3 (Audio only)
• MP4 (iPod, Zune HD)

Have you ever eyeballed your data to find an abnormality? Talk about an instant headache! See Guest speaker MVP Jessica Moss show developer tools are now integrated in Visual Studio as part of the SQL Server Client tools install...among them SQL Server Integration Services (SSIS) Data Profiling. This is a must see for anyone working with data. 

What is it?
SQL Server Integration Services object and application that allows you to interrogate, analyze, and discover information about existing data

Download Site: Included with SQL Server 2008 at  http://www.microsoft.com/sqlserver/2008

Example Problem(s) it solves:

• Prevent your data warehouse load from failing due to nulls by finding them before the load
• Identify new validation rules needed for a customer user interface
• Discover inconsistent or inaccurate code mapping values in your transactional system

Installation Notes:
Install SQL Server 2008 Integration Services client tools

Usage Notes:
Must connect to data in SQL Server 2000 or later

This is the seventh of Tool Shed Tooltips released from Episode 3 of the TV Show Russ Tool Shed presents... "It's All About The Tools" hosted by Russ Fustino and Co-Host Stan Schultes. Download code, ppt and demo script from http://code.msdn.com/toolshed for all episodes. Also, use the links on http://channel9.msdn.com/toolshed to download tools. Finally, check out some more great videos on the Developer Evangelist East site: http://channel9.msdn.com/dpeeast