x

Data profiler viewer

I have tried the Data Profiler Viewer after I've had SSIS create a file on one of my new tables. The table contains 176 million rows and 148 columns.

When I ran the Data Profiler on "Column Value Distribution Profiles" it only reported on 94 columns. Is there a known bug with this tool or am I doing something wrong?

How do you profile a table, where you want to know more about the contents of the table?

TIA, Henrik Staun Poulsen Stovi Software
more ▼

asked Jan 24, 2011 at 06:01 AM in Default

Henrik Staun Poulsen gravatar image

Henrik Staun Poulsen
579 13 15 16

Just a quick question - do you have permissions to see all the columns?
Jan 24, 2011 at 06:07 AM WilliamD
yes, I'm sysadmin, and sp_help shows all column.
Jan 24, 2011 at 06:23 AM Henrik Staun Poulsen

Were there always 148 columns or have they been added successively during development?

Is the meta-data up to date in he SSIS package?
Jan 24, 2011 at 06:42 AM WilliamD

They have always been there. There have been no meta data changes for one/two years on this table. How do you update meta-data in SSIS?

It is a data warehouse, where I wanted to check the resolution on all measure fields. We have 31 sources currently, and I need to work out a common denominator for the 31 tables. Time consuming, and I was so glad when I discoverd the Data Profiler SSIS task.
Jan 24, 2011 at 11:01 AM Henrik Staun Poulsen
SSIS is very picky about meta-data. The only way I know about refreshing is to remove and then add the object back into SSIS. Maybe someone else on here knows how to do a refresh without that hassle.
Jan 24, 2011 at 11:31 AM WilliamD
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

SSIS is very picky about meta-data. The only way I know about refreshing is to remove and then add the object back into SSIS. Maybe someone else on here knows how to do a refresh without that hassle.

more ▼

answered Jan 31, 2011 at 04:41 AM

WilliamD gravatar image

WilliamD
25.9k 17 19 41

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1833
x927
x579

asked: Jan 24, 2011 at 06:01 AM

Seen: 1410 times

Last Updated: Jan 24, 2011 at 06:01 AM