Search
InstantDoc ID
GO

Browse By: Author | Issue

June 27, 2008 04:27 PM

Server 2008 Data Profiling

Uncover the hidden treasure inside SQL Server 2008 Integration Services
Rating: (0)
Derek Comingore
SQL Server Magazine
InstantDoc ID #99003
Executive Summary: The Data Profiling task is an incredibly useful, yet often overlooked tool in Microsoft SQL Server 2008. This article explains how to configure and use both the Data Profiling task and the Data Profile Viewer (DPV) to examine and assess your data, then view the results in SQL Server Integration Services (SSIS).
...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

Hi rbailey,

You can use a wildcard character '*' for the column definition to for a given profile to scan all applicable data typed columns in a given table. You cannot use such a wildcard character for the table|view selection. What you could do however is dynamically generate the a given profile XML input. The ProfileInputXML is a property of the data profiling task which is a writeable property using the expressions tab of the task's editor.

Best Wishes
Derek

Derek9/10/2008 10:11:26 AM

Is there a way to profile all tables in a given database rather than setting up a connection for each table one by one ?

Rick9/9/2008 2:36:34 PM

You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.