I had the same issue. I was able to resolve it by changing the connection (id) property in the Control Flow tab on the Preparation SQL Task node.

I am not...

I had the same issue. As the other post mentioned the DataSource settings pages has two tabs. In the Impersonation Information tab, set the impoersonation to default and it should...