I am using DMF to migrate data from AX2009 to AX2012.
I have a few errors :
Is there anyone having sames issues? Is there any patch, is it a known bug?
Thanks for your support (if any...)
Had the same problem, seems like all numeric values has to be transformed to strings in the SQL statement when working with ODBC as source. Using varchar(50) should work fine, the important thing is that the string is big enough to handle the length of the numeric value.
Did you find an answer to your first error regarding the numeric issue?
Yeap, you just have to cast(<fieldname> as varchar(50))! Incredible no!
Perfect, nice to see that there is an answer.
Where exactly do you place this:cast(<fieldname> as varchar(50))? Is it in the sql statement specified in the entities in the processing Group?
I usually convert the value in the SQL statement. Something like this:
convert(nvarChar(50), T1.FieldName2) AS FieldName2,
from Table T1
In this case only the field FieldName2 is numeric. This makes it easy to rename the column if the field does not have the same name as the field in the staging table.
Hope this answers your question.