Hi,

I need to sort the node in my mapping but i can't do it wint the mapper of
Biztalk 2004.

I can do it with the external xslt but after i can't access on the my
database
with a script.

Do you know a solution about my problem ?

Thanks
Denis

[ Post a follow-up to this message ]

In the past, I used 2 maps inside the Construct Shape to overcome a similar
situation. The first map with external xslt and the 2nd map with BizTalk
Mapper. You can try a similar workaround.

--
Balaji Thiagarajan
MCP (BizTalk)
http://biztalkbits.blogspot.com
--

"Denis D" <Denis D@discussions.microsoft.com> wrote in message
news:441C6B01-BFC4-49C0-B1ED-24B19D1654AB@microsoft.com...
>
>  Hi,
>
>  I need to sort the node in my mapping but i can't do it wint the mapper
of
>  Biztalk 2004.
>
>  I can do it with the external xslt but after i can't access on the my
> database
>  with a script.
>
>  Do you know a solution about my problem ?
>
>  Thanks
>   Denis

[ Post a follow-up to this message ]

You can call any script from an external XSLT just as you can from a Map
file.
The Biztalk Mapper generates an XSLT file that is used in the transform.
The Custom XSLT Path option allows you override the XSLT file that is used.

What I have done is create the map using the Biztalk Mapper, including all
scripts.
"Validate" the map - this will output the XSLT into a file.
Copy this file into the project directory and add to the project. Edit the
<xsl:for-each> loop to add the <xsl:sort> nodes.
Update the map to use the new XSLT file using the Custom XSLT Path.
If you are using .NET assemblies in the map you may also need to create a
Custom Extension Xml file.

Greg


"Denis D" <Denis D@discussions.microsoft.com> wrote in message
news:441C6B01-BFC4-49C0-B1ED-24B19D1654AB@microsoft.com...
>
>  Hi,
>
>  I need to sort the node in my mapping but i can't do it wint the mapper
of
>  Biztalk 2004.
>
>  I can do it with the external xslt but after i can't access on the my
> database
>  with a script.
>
>  Do you know a solution about my problem ?
>
>  Thanks
>   Denis

[ Post a follow-up to this message ]