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



Comments

Popular posts from this blog

BizTalk Server 2013 Azure VM Log Shipping and HA for hosts

Azure DocumentDB Owner resource does not exist

SQL Server 2008 - High Memory Usage