It's probably getting confused as to what to connect you as because you put Integrated Security="";. As far as I'm aware Integrated Security should = True or SSPI or removed...

Are you updating every row in a partition of just a select amount of rows within a partition? If you are updating every record then the switch statement may help...