m********d 发帖数: 82 | 1 新客户的数据需要import到sql server 2000 database.其中一个column是notes field
,很长。在import过程中被告知text data being truncated。
请问如何才能不被truncate?谢谢。 |
s**********o 发帖数: 14359 | |
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 | |
m********d 发帖数: 82 | 12 是想学习新技术,可不知从何下手,你们几位大拿可否分享一下经验或者给几个CASE
STUDY,让我有个概念? |
m********d 发帖数: 82 | 13 我下载了sql server 2012 trial version,该从何入手学习?谢谢! |