Help regarding Biztalk orchestraion RRS feed

  • Question

  • Hello USers

    i am stuckd in one place in my biztalk solution,

    i have an orchestraion in which i am getting data from sql server (using generated schmema),and it its connected to decide shape,in which i have checked one of my database status column (by promoting property,as it is sql generate schmea i had to delete MAXOCCURENCE=UNBOUND),
    so now if status is approved i need to insert that row in another DB and if it is Pending than in another DB,now issue is if i take only one row in my source table it works fine,but if more than one row is there it creates problem,

    plz put some light on this issue,if i am on the right way or not,i do not know loop shape,how to use it,i am assuming that my sql receive adapter will return me all the rows as in SP from which the schema is generated return all row,so i think in decide shape every row should be checked

    Wednesday, February 24, 2010 11:17 AM


All replies