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

avatar image

Henrik Staun Poulsen
589 14 17 20

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
show all comments (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

avatar image

WilliamD
26.2k 18 33 48

(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.

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:

x2072
x1140
x738

asked: Jan 24, 2011 at 06:01 AM

Seen: 1694 times

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

Copyright 2016 Redgate Software. Privacy Policy