Well I changed the connection in the package to a windows account and now it works by the proxy, however I don't know why it wasn't working using a SQL account.