• >>I've tried it the logical way by selecting to execute task and the typing 'exec sp_....' and this obviosuly does not work. 

    It's pretty obvious that it does work, hence the large button at the bottom of the ExecSQL task UI labelled "Parameters".

    What are you trying to pass into the sproc as parameters ? Global DTS variables ?