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!

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: http://www.bimonkey.com/2010/06/the-row-sampling-transformation/ Hope this helps, Raymond Raymond Li - MSFT