none
Scheduled Task Adapter RRS feed

  • Question

  • I usually give the xml Query Statement in the scheduled task adapter like this

    <ns0:Select xmlns:ns0="http://schemas.microsoft.com/Sql/2008/05/ViewOp/dbo/PRODUCT"><ns0:Columns>*</ns0:Columns><ns0:Query>where NAME IN ('ABC','DEF')</ns0:Query></ns0:Select>
    Now I am constructing the XML query message inside the Orchestration,

    xmlVarMsg = new System.Xml.XmlDocument();
    xmlVarMsg .LoadXml("<ns0:Select xmlns:ns0=http://schemas.microsoft.com/Sql/2008/05/ViewOp/dbo/PRODUCT><ns0:Columns>*</ns0:Columns><ns0:Query>where NAME IN ('ABC','DEF')</ns0:Query></ns0:Select>");
    Message_Input =xmlVarMsg;

    Now I am not sure how to configure the Receive location with Scheduled task adapter without giving any task in that, but just to schedule it run everyday.

    Monday, March 23, 2015 12:45 PM

Answers

  • This is related to the other posts?

    Which Receive Location are you referring to?  You only need the one to start the parent Orchestration.

    In that case, it doesn't really matter what the message is, it's just something to launch the Orchestration.

    • Marked as answer by sid_siv Monday, March 23, 2015 1:39 PM
    Monday, March 23, 2015 12:57 PM
    Moderator