由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - Need help to read .xls to SQLServer2005 Through SSIS Wizard
相关主题
BI难在哪?我用sql server,visual studio,ssis做,就是扯控件,非常简单自如啊。SQL 2005 自带的SQL Server Business Intelligence Development Studio
SQL Server 2005 Exec( )急,SQL2005, 怎么查过去一小时里run过的所有query?
用SSIS EXPORT 到 EXCEL 2010 有2000个COLUMN,可能吗需要弄明白考什么database的证书
SSIS DYNAMIC EXCEL输出的问题问个SQL2005 backup/restore的问题
Need help, about select count(xyz) from ...SQL 2005 book
如何启动Visual Studio 2005中的Visual SQL 2005?SQL server 2005 deadlock
Database Encryption求大牛指教:VS2010搞出来的程序能跟SQL2005 express工作?
请问Reporting Service System (RSS) 客户安装Interview question about Microsoft Access and SQL. please help
相关话题的讨论汇总
话题: col8话题: col9话题: xls话题: wizard话题: ssis
进入Database版参与讨论
1 (共1页)
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的,类型自己可以选
1 (共1页)
进入Database版参与讨论
相关主题
Interview question about Microsoft Access and SQL. please helpNeed help, about select count(xyz) from ...
retrieving Chinese from database如何启动Visual Studio 2005中的Visual SQL 2005?
SQL Server 2005: How to hash a column?Database Encryption
Need help on finding dependency objects请问Reporting Service System (RSS) 客户安装
BI难在哪?我用sql server,visual studio,ssis做,就是扯控件,非常简单自如啊。SQL 2005 自带的SQL Server Business Intelligence Development Studio
SQL Server 2005 Exec( )急,SQL2005, 怎么查过去一小时里run过的所有query?
用SSIS EXPORT 到 EXCEL 2010 有2000个COLUMN,可能吗需要弄明白考什么database的证书
SSIS DYNAMIC EXCEL输出的问题问个SQL2005 backup/restore的问题
相关话题的讨论汇总
话题: col8话题: col9话题: xls话题: wizard话题: ssis