Mattie,

Using a proxy requires a Windows account - you can't use a SQL login for this. However, you can configure the connection manager inside the SSIS package to use a username/password login instead.

I hope this helps!
~Tim