由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - Import data from excel into sql server 2000
相关主题
Truncation error import csv file to SQL tableerror file或者exception file
sql server 怎么关掉log想做几个SQL development的project
I HATE Micro$oftinput into access
Re: Is there any easy way to truncate the LDF file of SQL SERVER?Oracle求助,thanks!!!
请大家给我推荐一下SSIS的书从SQL Server 2000升级到SQL Server 2005
求助:ssis输出到excel,自动在每个cell添加了single quote。如何避免Import 50GB data from multiple .txt file into MS SQL database
SSIS import and export wizard 搞不定了要面试SQL Server工作,请教高手
SQL 2005 Intergration Service QSSIS package import excel, 只能load 255 rows
相关话题的讨论汇总
话题: import话题: text话题: sql话题: data话题: server
进入Database版参与讨论
1 (共1页)
m********d
发帖数: 82
1
新客户的数据需要import到sql server 2000 database.其中一个column是notes field
,很长。在import过程中被告知text data being truncated。
请问如何才能不被truncate?谢谢。
s**********o
发帖数: 14359
2
存成CSV试试,TABLE建好TEXT
m********d
发帖数: 82
3
still not working. same error.
error message:
Error 0xc02020a1: Data Flow Task: Data conversion failed. The data
conversion for column "MEMBER_Notes" returned status value 4 and status text
"Text was truncated or one or more characters had no match in the target
code page.".
(SQL Server Import and Export Wizard)

【在 s**********o 的大作中提到】
: 存成CSV试试,TABLE建好TEXT
B*****g
发帖数: 34098
4
google "Text was truncated or one or more characters had no match in the
target code page."
前两个return:
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationser
http://stackoverflow.com/questions/8629024/text-was-truncated-o

text

【在 m********d 的大作中提到】
: still not working. same error.
: error message:
: Error 0xc02020a1: Data Flow Task: Data conversion failed. The data
: conversion for column "MEMBER_Notes" returned status value 4 and status text
: "Text was truncated or one or more characters had no match in the target
: code page.".
: (SQL Server Import and Export Wizard)

m********d
发帖数: 82
5
It worked, Thanks Beijing and smallburrito for your suggestions!
I did below steps:
1.copied the row with the longest note to the first column of the excel.
2.saved the file as text file.
3. in the import/export wizard, I chose "flat file source", then in the "
advanced" option, I changed the note field from string[dt_str] to text
stream [DT_TEXT].
And it worked!
Thanks Again for your help!
z******4
发帖数: 4716
6
有这么麻烦吗,是因为你在建job是利用导入功能,他会默认一个长度
你把这个job修改下就可以了,记住过程中所有的长度都要改
m********d
发帖数: 82
7
可以更详细一些吗?你说的JOB是SQL SERVER AGENT JOB 吗?在哪里可以改默认长度?
Thanks for your input!
s**********o
发帖数: 14359
8
要没用SSIS要么用IMPORT WIZARD,里面有MAP的,要吧EXCEL的长度改一下,不过EXCEL
IMPORT是很烦人的,64BIT的基本不WORK,32BIT也老出错。忘了他用的是2000,DTS
IMPORT WIZARD
z******4
发帖数: 4716
9
你用的是import wiz,最后一步选择生成package,然后打开package 好像要安装
business studio,你就能看到了
job不是package,job包含package
你随意倒腾一下,以后可以做参数,避免每个excel都手工导入了

【在 m********d 的大作中提到】
: 可以更详细一些吗?你说的JOB是SQL SERVER AGENT JOB 吗?在哪里可以改默认长度?
: Thanks for your input!

z******4
发帖数: 4716
s**********o
发帖数: 14359
11
2000都被淘汰了,别学啦
m********d
发帖数: 82
12
是想学习新技术,可不知从何下手,你们几位大拿可否分享一下经验或者给几个CASE
STUDY,让我有个概念?
m********d
发帖数: 82
13
我下载了sql server 2012 trial version,该从何入手学习?谢谢!
1 (共1页)
进入Database版参与讨论
相关主题
SSIS package import excel, 只能load 255 rows请大家给我推荐一下SSIS的书
求科普database方向求助:ssis输出到excel,自动在每个cell添加了single quote。如何避免
微软太行为艺术了SSIS import and export wizard 搞不定了
remove unprintable characters...SQL 2005 Intergration Service Q
Truncation error import csv file to SQL tableerror file或者exception file
sql server 怎么关掉log想做几个SQL development的project
I HATE Micro$oftinput into access
Re: Is there any easy way to truncate the LDF file of SQL SERVER?Oracle求助,thanks!!!
相关话题的讨论汇总
话题: import话题: text话题: sql话题: data话题: server