BizTalk Server General - convert integer to hexadecimal value and put in positional flat file

Author

convert integer to hexadecimal value and put in positional flat file

wask

2005-10-24, 8:48 pm

HI

My Receive port receive the data from SQL Server and send the data to
MQSeries as positional flat file.
I need to convert 177(integer) value to 00B1(hexadecimal) and put into
flat file and send to MQSeries.
I created a map with hexadecimal functoids and i used this map in send
port outbound maps.when i check in my MQSeries it show some thing like
this
---------------------------------
hexadecimal Asci

20 37 32 30 44 .170D

-------------------------------------

My result should like this

hexadecimal ASCI
--------------------------------------

00 B1 00 00 44 ....D
--------------------------------------

x(field name) with xsd:string datetype
position start= 1, length=2 bytes

can any tell me how to convert integer value to hexadecimal value and
put it in positional flat file.

thanks
wask