I have worked around the issue with an SSIS package, I am aware of the Trustworthy option and the security implications which is why I opted not to use it.

I...