I have receive location that generates this stored:
select fldid,flddate,fldflag from tblUpdateADLog where fldflag = 0 for xml auto,xmldata
update tblUpdateADLog set fldflag = 1
insert into tblUpdateADLog (fldflag) values (0)
I distinguish the fldid field.
Every 15 sec. interval, BT is executes the stored and new row inserted.
The only problem is that I can’t get the distinguish fldid value.
msgIn.tblUpdateADLog.fldid
\”Im getting: object reference not set to an instance of an object\”
Im using xmlrecieve as pipeline type.
Any idea?