question

Henrik Staun Poulsen avatar image
Henrik Staun Poulsen asked

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
sql-server-2008ssissql-server-2008-r2
6 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image WilliamD commented ·
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.
1 Like 1 ·
WilliamD avatar image WilliamD commented ·
Just a quick question - do you have permissions to see all the columns?
0 Likes 0 ·
Henrik Staun Poulsen avatar image Henrik Staun Poulsen commented ·
yes, I'm sysadmin, and sp_help shows all column.
0 Likes 0 ·
WilliamD avatar image WilliamD commented ·
Were there always 148 columns or have they been added successively during development? Is the meta-data up to date in he SSIS package?
0 Likes 0 ·
Henrik Staun Poulsen avatar image Henrik Staun Poulsen commented ·
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.
0 Likes 0 ·
Show more comments

1 Answer

·
WilliamD avatar image
WilliamD answered
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.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.