ToolShed Tooltip #20 - SSIS Data Profiling saves your eyeballs

Play ToolShed Tooltip #20 - SSIS Data Profiling saves your eyeballs
Sign in to queue


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

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 for all episodes. Also, use the links on to download tools. Finally, check out some more great videos on the Developer Evangelist East site:



Right click to download this episode

The Discussion

Add Your 2 Cents