Row Sampling Transform

The "Sampling Value" is now exposed on the Control Flow so we can use expressions to determine the amount of rows that flow through a pipeline . What is missing as far as I can see is the ability to say "ALL".

I know I could remove the transform but what if I do not want to touch the packages. The way i will set the value is through DTExec.

This would be useful for testing in that I could have a series of runs and each one ramping up the row counts. The final one would be "ALL" but without something on the transform to say "ALL" I would need to determine the count of rows up front. A waste IMHO.
I suppose the workaround is to use the % sampling transform and specify 100%.
Allan
www.sqlis.com
Allan\stick it on the SSIS Requests thread Allan...