data profiler int limit??
does anyone know of a sql data profiling task limitation to an INT? i have a rather large table (2.2BB rows) and the rowcount is definitely in excess of an int when running a profile request the task errors out with an arithmetic overflow converting expression to data type int. i'm boggled by this as i cant figure out the cause of it. is this internal to the profiler or can i tweak this in some way? thanks a bunch for your help!
November 11th, 2010 2:17pm

Hi, Not sure if the error is caused by the large data set, but you can test with data sampling transform to generate a small sub dataset. If the error still occurs, please post the detailed error message. Regarding sampling transform, you can refer to: Hope this helps, Raymond Raymond Li - MSFT
Free Windows Admin Tool Kit Click here and download it now
November 13th, 2010 4:39am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics