Using BizTalk to bridge SQL Job and Human Intervention (Requesting Permission)
- by Kevin Shyr
I start off the process with either a BizTalk Scheduler (http://biztalkscheduledtask.codeplex.com/releases/view/50363) or a manual file drop of the XML message. The manual file drop is to allow the SQL
Job to call a "File Copy" SSIS step to copy the trigger file for the next process and allows SQL
Job to be linked back into…