Tool Shed Tooltip #20 Published - SSIS Data Profiling saves your eyeballs
Link: http://channel9.msdn.com/shows/toolshed/ToolShed-Tooltip-20-SSIS-Data-Profiling-saves-your-eyeballs/
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
Comments
New Comments to this post are disabled
About rfustino
Russ wisely shelved dreams of rock and roll stardom in order to share his vast knowledge with developers nationwide. Given that he can’t sing or play an instrument, other than in Guitar Hero, we’re all very grateful. Russ has more than 25 years of software development. He’s the creator of the Russ' Tool Shed developer seminar series and has donned his trademark suspenders, hardhat and tool belt in presentations for over 75,000 developers at 1,700 events. Russ also has expertise in developing Visual Basic and Web-based solutions using Microsoft tools. Before joining Microsoft eleven years ago, Russ worked as a VB instructor, headed up a development department, and created several client/server applications and system software products. His specialties include development with VB.NET, XML Web services, ASP.NET, XNA, Silverlight, Development Tools and debugging. But make no mistake – Russ is not all brains. His big heart led him to establish Take a Swing at Cancer, Inc., a non-profit organization that holds softball and golf-based fundraisers to battle cancer. You have to know the code to get in the shed. KNOW THE CODE!
