Create an OLEDB connection to your database.

Add an Execute SQL task - specify the above connection.

Click on Expressions in the task editor and then expand the Expressions item to get the Property Expressions Editor. Click on the Property drop-down and find the SqlStatementSource property - enter the required expression against it (eg "exec dbo.usp1").

That should be enough.

Phil