sorry for replying late.
As a temporary workaround you can use SQL authentication saved inside your connection manager. Delegation issues happen only when you connect from a different machine. Why don't you try creating an SQL agent job on the server and try running it manually through ssms