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
asked Jan 24, 2011 at 06:01 AM in Default
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.
answered Jan 31, 2011 at 04:41 AM