ToolShed Tooltip #20 - SSIS Data Profiling saves your eyeballs

Sign in to queue

Description

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 https://channel9.msdn.com/toolshed to download tools. Finally, check out some more great videos on the Developer Evangelist East site: https://channel9.msdn.com/dpeeast

Embed

Download

Download this episode

The Discussion

Add Your 2 Cents