WCF-SQL adapter and one way polling using Stored Procedures.

Hello to all,

I’ve got some scenario to build with BTS 2009:

Im using BTS2009, and I have some table to poll data from (this should happen every night, no outcoming invoking process/message). While I want to create schemas by consuming adapter service, I can choose contract type: a server or a client. If I wish to use stored procedures, I need to choose a server contract type, but then I need to send some request from an orchestration to SQL (and I don’t want to do it). If I select client, I can poll data one-way (need no parameter to send or some way to invoke orchestration), but in such case I can’t use stored procedure. Is there a way to use stored procedure, but with contract type as a client? With no passing parameters or without a need to awake orchestration from outside?