Execute SQL Task : IsQueryStoredProcedure property

The IsQueryStoredProcedure is only available if you use an ADO connection. It is greyed out if you use an OLE DB connection. With a little tweaking, you can still reliably execute stored procedures from an OLE DB connection.

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/895c911c-27ec-41e4-894d-efb2cbbd660a