ToolShed Tooltip #20 - SSIS Data Profiling saves your eyeballs

Download this episode

Download Video

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

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.