Hi there

I realise that you have worked it out, but recently i had a similar problem and had to use the Execute Sql task. This document is really helpful

http://technet.microsoft.com/en-us/library/ms140355.aspx

I used this to walk through the process and it worked miraculously

Cheers