I'm currently attempting to profile a deep and wide dataset using SQL Data Profiler; however we I choose the Numeric Profile Data Type Option the Profiling Process Fails. Providing me with an Error stating:
Error converting data type VARCHAR to BIGINT
Is there any way that I can work around this without changing the table I am wishing to profile?
The data set being profiled is an MS SQL Server 2014 data set that has been loaded from SAS data set; and has not been assigned the most appropriate data types from SQL.
This may be a bug that slipped through because we did not have access to such a large dataset with a sub-optimal assignment of data types (per your other recent forum post). We are not aware of a workaround at this time. We added this bug to our issue tracking system.