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 呵呵 嘿嘿
|