It was clear! I was just using the wrong terminilogy in reply.

All sorted now. The whole reason I started going down the Execute SQL Task route is because I couldn't...

Thanks Phil

Good to have that confirmed. It was the lack of mapping between the DFT and the Exceil destination that was throwing me but I have a couple of things...

To the OP (if still around) did you solve this easily?

This is also the problem I am having.

I want to execute a stored proc and output the results to an...

Thanks Antony

The only issue I suppose then would be if I didn't change my password for the datasource when I change my Windows password, or if I was suddenly off...