n********6
发帖数: 1511 | 1 Environment: Win2003, SQL2005,
Process: Load .xls by using SSIS Wizard (DB->Task->Import Data)
.xls File Structure: (col1, col2, ..., col8, col9)
Columns: col8:numbers; col9: numbers
First Line: xx, xx,... xx, xx (to set col8, col9 character)
Loading result:col1, col2, ... col8 (nvarchar), col9(float)
Question: Why col8 nvarchar while col9 float?
Thank you. | n********6
发帖数: 1511 | 2 Possible answer:
SQL define the col format by the first 8 rows, and the format with most
number of cells will be the format for that column. | i****a
发帖数: 36252 | 3 this can be controlled if you go to column settings when you setup the
import
【在 n********6 的大作中提到】
: Environment: Win2003, SQL2005,
: Process: Load .xls by using SSIS Wizard (DB->Task->Import Data)
: .xls File Structure: (col1, col2, ..., col8, col9)
: Columns: col8:numbers; col9: numbers
: First Line: xx, xx,... xx, xx (to set col8, col9 character)
: Loading result:col1, col2, ... col8 (nvarchar), col9(float)
: Question: Why col8 nvarchar while col9 float?
: Thank you.
| n********6
发帖数: 1511 | 4 thank you for your help. | g***l
发帖数: 18555 | 5 import的时候要MAP COLUMN的，类型自己可以选 |
|
