- This topic has 1 reply, 1 voice, and was last updated 8 years, 3 months ago by
.
-
Posts
-
-
In BizTalk 2006, I am about to create a map with an \”SQL Adapter\” supplying the \”source schema\” from MS SQL Server, while an EDI document becomes the \”destination schema\”.
If this process is to be done automatically, what event actually puts everything into motion? Would SQL Server start this process? If so, what would it use? A stored procedure? A trigger?
Thank you in advance for your response.
Mike
-
You have two choices:
1) Set up an SQL Receive Port – the data retrieved will activate the orchestration with the activating receive (first receive at top of orchestration). This port would poll every x seconds (or minutes).
So you would need to delete the data or flag the data as being already processed so the same data doesn’t reprocess every time the polling intervals comes around again.2) Set up a Send Port (request/response) – You receive some other message that starts your orchestration, then you call the stored proc by doing a send/receive to this send port.
Perhaps this helps, or you can describe more fully what it is you are trying to do.
I have full video examples available at site below.
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.