One problem we frequently had with CDATA SSIS is that if the wrong password was entered, it automatically retried a few times. It is very easy to lock yourself out with that connector