Hi,

What error are you getting? the OLE DB datasource will work if you choose 'SQL command' as the Data access mode and in the SQL command text use

exec spName with ? for each parameter (if any).

Click parameters to map the stored procedure parameter name(s) (including @) to a variable(s).