The answer came form Dave Robinson - one of the great guys at Solidsoft (WWW.Solidsoft.com)
- In your schema which defines your stored procedure (for insert etc) you need to set the xml body field to a distinguished field.
- When mapping from your source schema to your sql schema you will map the values that you want and also you have to map a ‘dummy’ entry to the body parameter (because it’s a distinguished field it must be initiliazed).
- After your map use a message assignment shape to set the distinguished field to the inputdoc.outerxml (or if you don’t want the full document then you will need to do some XmlDocument manipulation).