由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - Issue with SSIS export to a flat file and to importy as well
相关主题
SSIS import and export wizard 搞不定了白痴级别问题来了
怎样从WEB上执行调用DTS TASK?SQL Server 2008 Exp 怎么export DBF file?
sql server 2005 问题oracle -> ms sql
如何从一个Stored Procedure中实时返回运行信息如何复制数据最快?
新手求助:关于数据库同步的问题Import 50GB data from multiple .txt file into MS SQL database
sql server 怎么关掉log要面试SQL Server工作,请教高手
SQL Server 2005 Exec( )问题求教:怎样从MS SQL 转送数据到oracle
从SQL Server 2000升级到SQL Server 2005哪里能找到SSIS的VIDEO教程啊
相关话题的讨论汇总
话题: error话题: data话题: code话题: source话题: flow
进入Database版参与讨论
1 (共1页)
D*******z
发帖数: 319
1
Here is the error message. Any ideas? Thanks.
Started: 3:00:00 AM Error: 2011-09-26 05:53:00.76 Code: 0xC02020A1
Source: Data Flow Task 1 Destination - astromembers_txt [154]
Description: Data conversion failed. The data conversion for column "
FirstName" returned status value 4 and status text "Text was truncated or
one or more characters had no match in the target code page.". End Error
Error: 2011-09-26 05:53:00.76 Code: 0xC02020A0 Source: Data Flow
Task 1 Destination - astromembers_txt [154] Description: Cannot copy or
convert flat file data for column "FirstName". End Error Error: 2011-09-26
05:53:00.76 Code: 0xC0047022 Source: Data Flow Task 1 SSIS.Pipeline
Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The
ProcessInput method on component "Destination - astromembers_txt" (154)
failed with error code 0xC02020A0 while processing input "Flat File
Destination Input" (155). The identified component returned an error from
the ProcessInput method. The error is specific to the component, but the
error is fatal and will cause the Data Flow task to stop running. There may
be error messages posted before this with more information about the
failure. End Error Error: 2011-09-26 05:53:18.26 Code: 0xC02020C4
Source: Data Flow Task 1 Source - Query [1] Description: The attempt to
add a row to the Data Flow task buffer failed with error code 0xC0047020.
End Error Error: 2011-09-26 05:53:18.26 Code: 0xC0047038 Source:
Data Flow Task 1 SSIS.Pipeline Description: SSIS Error Code DTS_E_
PRIMEOUTPUTFAILED. The PrimeOutput method on component "Source - Query" (1)
returned error code 0xC02020C4. The component returned a failure code when
the pipeline engine called PrimeOutput(). The meaning of the failure code
is defined by the component, but the error is fatal and the pipeline stopped
executing. There may be error messages posted before this with more
information about the failure. End Error DTExec: The package execution
returned DTSER_FAILURE (1). Started: 3:00:00 AM Finished: 5:53:18 AM
Elapsed: 10397 seconds. The package execution failed. The step failed.
i****a
发帖数: 36252
2
it's very clear: data in the field named "FirstName" is too long for your
database or SSIS definition


or
26
Pipeline

【在 D*******z 的大作中提到】
: Here is the error message. Any ideas? Thanks.
: Started: 3:00:00 AM Error: 2011-09-26 05:53:00.76 Code: 0xC02020A1
: Source: Data Flow Task 1 Destination - astromembers_txt [154]
: Description: Data conversion failed. The data conversion for column "
: FirstName" returned status value 4 and status text "Text was truncated or
: one or more characters had no match in the target code page.". End Error
: Error: 2011-09-26 05:53:00.76 Code: 0xC02020A0 Source: Data Flow
: Task 1 Destination - astromembers_txt [154] Description: Cannot copy or
: convert flat file data for column "FirstName". End Error Error: 2011-09-26
: 05:53:00.76 Code: 0xC0047022 Source: Data Flow Task 1 SSIS.Pipeline

i*****w
发帖数: 75
3
Open your destination (Flat file connectiong string) and increase the column
length of the FirstName column and try again.


or
26
Pipeline

【在 D*******z 的大作中提到】
: Here is the error message. Any ideas? Thanks.
: Started: 3:00:00 AM Error: 2011-09-26 05:53:00.76 Code: 0xC02020A1
: Source: Data Flow Task 1 Destination - astromembers_txt [154]
: Description: Data conversion failed. The data conversion for column "
: FirstName" returned status value 4 and status text "Text was truncated or
: one or more characters had no match in the target code page.". End Error
: Error: 2011-09-26 05:53:00.76 Code: 0xC02020A0 Source: Data Flow
: Task 1 Destination - astromembers_txt [154] Description: Cannot copy or
: convert flat file data for column "FirstName". End Error Error: 2011-09-26
: 05:53:00.76 Code: 0xC0047022 Source: Data Flow Task 1 SSIS.Pipeline

g***l
发帖数: 18555
4
是的,超长,SOURCE TABLE里CHECK一下FIRSTNAME的长度,MAX(LEN(FRISTANME)),如果
有SPACE要TRIM
D*******z
发帖数: 319
5
这些我都已经做过,就是不行,会不会是 ' apostrophe 的原因呢?
g***l
发帖数: 18555
6
你的MAPPING做了没有,PREVIEW一下啊不就知道对不对了

【在 D*******z 的大作中提到】
: 这些我都已经做过,就是不行,会不会是 ' apostrophe 的原因呢?
i*****w
发帖数: 75
7
What is your data source, Excel or DB? Are you using Unicode in the First
Name column?


or
26
Pipeline

【在 D*******z 的大作中提到】
: Here is the error message. Any ideas? Thanks.
: Started: 3:00:00 AM Error: 2011-09-26 05:53:00.76 Code: 0xC02020A1
: Source: Data Flow Task 1 Destination - astromembers_txt [154]
: Description: Data conversion failed. The data conversion for column "
: FirstName" returned status value 4 and status text "Text was truncated or
: one or more characters had no match in the target code page.". End Error
: Error: 2011-09-26 05:53:00.76 Code: 0xC02020A0 Source: Data Flow
: Task 1 Destination - astromembers_txt [154] Description: Cannot copy or
: convert flat file data for column "FirstName". End Error Error: 2011-09-26
: 05:53:00.76 Code: 0xC0047022 Source: Data Flow Task 1 SSIS.Pipeline

D*******z
发帖数: 319
8
Data source a view of sql sever 2008. I did not Unicode string [DT_WSTR]
D*******z
发帖数: 319
9
原来是中文的原因
id title firstname lastname
135177135 NULL 呵呵 嘿嘿
i*****w
发帖数: 75
10
中文 is unicode.

【在 D*******z 的大作中提到】
: 原来是中文的原因
: id title firstname lastname
: 135177135 NULL 呵呵 嘿嘿

1 (共1页)
进入Database版参与讨论
相关主题
哪里能找到SSIS的VIDEO教程啊新手求助:关于数据库同步的问题
I HATE Micro$oftsql server 怎么关掉log
编程高手来说说怎么做效率高?SQL Server 2005 Exec( )
Import data from excel into sql server 2000从SQL Server 2000升级到SQL Server 2005
SSIS import and export wizard 搞不定了白痴级别问题来了
怎样从WEB上执行调用DTS TASK?SQL Server 2008 Exp 怎么export DBF file?
sql server 2005 问题oracle -> ms sql
如何从一个Stored Procedure中实时返回运行信息如何复制数据最快?
相关话题的讨论汇总
话题: error话题: data话题: code话题: source话题: flow