I am able to run the SSIS package just fine by itself, and I am using my sql account. The issue happens when I add it to the SQL server...

How do I do to each group so one group row doesn't affect the other group?

I used the following code: = iif (RunningValue( Fields!YourField.Value , CountDistinct, Nothing) mod 2, "White",...