biztalk sql adapter

hi, i'm developing biztalk solution using sql adapter r2 2006 pack. i'm polling table living on sql database records -  created via trigger on "main" sql table (update, insert, delete). polling achieved stored procedure executed @ timed interval.

intention delete record secondary table once poll has retrieved message - oracle delete after poll event (basically loop in orchestration , issue delete statement on record polled , in orchestration)

however, when came transform message using mapping engine results i'm recieving poll, sql schema not providing me way of mapping each field results delete/update updategram.

can shed light why can map between getrecord header , not results returned header?

i tried same thing , works fine me.

here did validate said:

-> created simple receive scenario in select data database table
-> created map separately schema obtained above , schema delete updategram
-> tested map input got in first point above (the select response) -
     -> generated output using map (right click map , see properties more info on testing , validating map)
-> used output generated map in plain pass through pipeline scenario (using pass through pipelines in receive port , send ports receive input xml directory, execute operation , dump response)
    -> above worked without error

can try testing map?

---

abhinav

BizTalk Server  >  BizTalk Server Adapters and Adapter Pack