Windows Server - parent/child relationship with updategram

I reviewed the article here:

http://blogs.msdn.com/skaufman/archive/2005/01/31/363920.aspx

Does Kaufman's example work with BT2006R1?  My BT instance complains
that there must be at least one input to a concatenation functoid.  Is
there a pure xsl solution to the problem of inserting parent-child
data with updategrams?

  Eric Stott replied...

you have to put a value in there the letter a for example
Eric
http://blog.biztalk-info.com

  jemkem replied...

Then whatever I put there becomes the placeholder.  Very cool.  Thanks!

  Eric Stott replied...

Yes SQLXML is cool in some ways!!!

Eric
http://blog.biztalk-info.com

The 'urn:schemas-microsoft-com:xml-updategram:at-identity' attribute is not declared Windows Server When I validate this doc against the schema, I get the error: The 'urn:schemas-microsoft-com:xml-updategram:at-identity' attribute is not declared Looks like at-identity is declared in the instance schema. Any ideas? Instance looke like - - <ns0:DB_Request xmlns:updg = "urn:schemas-microsoft-com:xml- updategram" xmlns:ns0 = "http: / / CastlePines810"> - <ns0:sync> - <ns0:after> invoice_date = "2007-03-30" vend_inv_no = "109033721-01 part_no = "MCS-7835-H1-ECS1" qty_received = "1" unit_cost = "4124.1" / > Schema is - microsoft-com:xml-updategram" xmlns:b = "http: / / schemas.microsoft.com / BizTalk / 2003" attributeFormDefault = "unqualified" elementFormDefault = "qualified" targetNamespace = "http: / / CastlePines810" xmlns:xs = "http: / / www.w3.org / 2001 / XMLSchema"> microsoft-com:xml-updategram" / > updategram" / > updategram" updategram:Prefix = "updg" minOccurs = "1" maxOccurs = "unbounded" name = "sync"> maxOccurs = "unbounded" name = "after"> name = "w_VendorInvoiceHeader"> type

All updategram nodes with siblings must have ids - ERROR Windows Server Getting the following error while trying to update multiple rows using UPDATEGRAM in Biztalk Server 2006. Message which goes into SQL Send Adapter : - <ns0:UpdateProcessStatusRequest xmlns:ns0 = "http: / / Test.SQLUpdatesSend" xmlns:updg = "http: / / Test.Updategram"> - <ns0:sync> - <ns0:before> - <ns0:after> UID = "288E0688-4A06-493E-A70E-B916251E7CCA" DateProcessed = "2007-03 DateProcessed = "2007-03-30" / > Error logged in Event LOG : Error Description: HRESULT = "0x80004005" Description = "All updategram / diffgrams nodes with siblings must have ids, either user specified ones or mapping schema based key field id" ?<Root xmlns:ns00 = "urn:schemas-microsoft-com:xml-updategram"> <?MSSQLError HResult = "0x80004005" Source = "Microsoft XML Extensions to SQL Server" Description = "All updategram / diffgrams nodes with siblings must have ids, either user specified ones or mapping schema based A09B-9B98645FB1F9} Instance ID: {11E42BFB-675A-4E43-80D5-B8F068FA1B9F} Error Description: HRESULT = "0x80004005" Description = "All updategram / diffgrams nodes with siblings must have ids, either user specified ones or mapping schema based key field id" ?<Root xmlns:ns00 = "urn:schemas-microsoft-com:xml-updategram"> <?MSSQLError HResult = "0x80004005" Source = "Microsoft XML Extensions to SQL Server" Description = "All updategram / diffgrams nodes

Updategram vs Sql SoredProcedure. Which to choose and why Windows Server Hi all, i am writing a BizTalk application. i am unble to decide which to choose from Updategram or SoredProcedure. Please anyone help me out on some strong points. Any suggestion is appreciated MCSD (1) IMHO If your case is the simple Add / Update-ing several rows, the Updategram give you more simple way. You completely were out of the SQL code. SP give ugidotnet.org / biztalk / - - Nino Crudele (MCAD-MCSD.NET-MCT) http: / / blogs.ugidotnet.org / biztalk / keywords: Updategram, vs, Sql, SoredProcedure., Which, to, choose, and, why description: Hi all, i am writing a BizTalk application. i am unble to decide which to choose from Updategram or SoredProcedure. Please anyone help me out on some s