B*********L 发帖数: 700 | 1 原数据是192752000000504124,传到MSSQL这边变成了192752000000504000,所有最后
三位变成0了。没有error,也没有warning。
有谁知道怎么解决吗? |
j*****n 发帖数: 1781 | 2 I'd try to use numeric data type or simply varchar type for this field on
sql server. |
B*********L 发帖数: 700 | 3 Thanks. it is a index column. I was using bigint type. i'll try numeric or
vachar.
【在 j*****n 的大作中提到】 : I'd try to use numeric data type or simply varchar type for this field on : sql server.
|
B*********L 发帖数: 700 | 4 it works now. instead of create/edit data flow tasks in an old ssis package.
i create a new ssis package, then everything works fine. |