|
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
(comments are locked)
|
|
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.
(comments are locked)
|
Your answer
Just a quick question - do you have permissions to see all the columns?
yes, I'm sysadmin, and sp_help shows all column.
Were there always 148 columns or have they been added successively during development?
Is the meta-data up to date in he SSIS package?
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.
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.