decimal being rounded in v2008
Posted on 2009-05-04
Odd little thing I just noticed....
my datasource is SQL v2000, 'price' is the attribute in question, it is DECIMAL 9(18,8)
my destination is SQL v2008, 'price' is the same, it is DECIMAL 9(18,8)
I'm using v2008 SSIS to copy the data from source to destiniation (until we upgrade and get off the v2000 box). it's a flat file source, created from a simple bcp out of the v2000 box, into sql server destination. that's it. no conversions, no nothing.
but get this... my price is being rounded
i've checked the current flat file. the price values are in there just fine, non-rounded.
and yes, I am certain that I am looking at the same record in source vs destination. there's a TON of data in this thing. i transferred upwards of 5M this morning, i just noted that price thing, so i've dug a little deeper and find that NONE of the prices equate. not just today's 5M, but everything I've checked. they've all been rounded down in the v2008 instance. like this:
any ideas at all?