Can you confirm if the SQL server authentication login you are using belongs to the Admin group or has admin rights, if not try with admin rights and it should work.

I too had the same issue and i did not change to OLEDB rather executed the package with admin account

Thanks.