j*****n 发帖数: 1781 | 1 MSSQL 2k5
Here is a table with about 400 columns, billions of rows; we have a view
does this:
SELECT .....,
CAST (col_n AS VARCHAR(11)) AS col_n, -- col_n is MONEY data type in the
table
...
FROM tbl
We have an SSIS ETL runs every day that pulling millions of rows based on
this view; it has been ran for couple years without problem.
Recently (started few weeks ago), we discovered that randomly this converted
col_n returns few 0's, no matter whatever the actual value is. say 20.12,
or -128.33, it returned '0'.
Anyone any idea? 50 baozi for answer... thanks! | i****a 发帖数: 36252 | 2 sounds strange.
can it be reproduced or does it only show up in the log/result after
your SSIS run?
would it be possible the source data is actually 0 when you run it?
view
the
on
【在 j*****n 的大作中提到】 : MSSQL 2k5 : Here is a table with about 400 columns, billions of rows; we have a view : does this: : SELECT ....., : CAST (col_n AS VARCHAR(11)) AS col_n, -- col_n is MONEY data type in the : table : ... : FROM tbl : We have an SSIS ETL runs every day that pulling millions of rows based on : this view; it has been ran for couple years without problem.
|
|