I am importing a table from our ERP system using a DTS. THe table imports fine. The only issue that I am having is that a decimal field in our ERP system can be for example 105.1275, but when it gets inported to sql the number is 105.1270.
What could possibly be the issue and sollution for this. All help is appreciated.Ummm... what's the source platform of the data and the destination platform?
That'll learn you for using DT...uh...I can't say it...
Did you look at the transformation? Waht's the DDL of the source and destination look like?|||Check that the precision/length settings for the destination field is correct.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment