| Joe Barton 2004-08-12, 5:52 pm |
| You may want to try a custom functiod, use a convert
function from string to integer with two dec.
Now if you have say a 0000567.97 as a varchar, the
function may work, as well for 89720 resulting in
00089720.00. If the filed has 567.97, converting to
integer +2 dec, well not sure what the result would be,
but in your output schema, look at the options available
for filed length etc.
Hope this gives some clues.
>-----Original Message-----
>When using the SQL adapter in Biztalk 2004 to insert
records into a field that has the datatype set to money in
SQL server the Bitalk server logs the following error:
>
>The adapter "SQL" raised an error message.
Details "HRESULT="0x80040e07"
>Description="Disallowed implicit conversion from data
type nvarchar to data
>type money, table 'Testing.dbo.S_Salary',
column 'Salary'. Use the CONVERT
>function to run this query."
><<<<<<<<<<<<<<<<<
>
>My question is how do you insert into a field that has
the datatype set to money with Biztalk 2004?
>
>Any help would be greatly appreciated!
>
|