Hi, I am using an XML Source to specify some default values for columns which ultimately get inserted into a legacy ERP system. One column in partucular in the ERP is defined as a decimal of precision 5, scale 2 (i.e. basically a percentage). Anyway in the XSD I have defined the column as: <xs:element name="YP_PSP_EFF_FACTOR"> <xs:simpleType> <xs:restriction base="xs:decimal"> <xs:totalDigits value="5" /> <xs:fractionDigits value="2" /> </xs:restriction> </xs:simpleType> </xs:element> But the XML Source is defining the SSIS data type as the fixed scale DT_DECIMAL with a scale of 10. Using that data type and scale/precision cause insert problems into the ERP. A useable data type would be DT_NUMERIC(5,2). My question is: is there any way in the XSD to specify so SSIS reads in as DT_NUMERIC(5,2)? At the moment I have to use the advanced editor to change the column data types manually. I seem to had no luck in finding an XSD to SSIS data type conversion shart or anything which may point me in the right direction. Thanks Peter

Hi Peter, Could you please send the files to reproduce the issue? If possible, you can send the file to sqltnsp AT microsoft dot com Thanks, Jin ChenJin Chen - MSFT

Hi Peter, Could you please send the files to reproduce the issue? If possible, you can send the file to sqltnsp AT microsoft dot com Thanks, Jin ChenJin Chen - MSFT

Email sent, thanks.

Was there any resolution to this? We're having the same issue! Kristianhttp://blogs.conchango.com/kristianwedberg

Not sure why a Data Conversion Task after the transform cannot help there. Did you try?Arthur My Blog