March 10, 2008 at 2:31 am
Hi all,
I have a issue need your great help. Would you please help to check it and tell mw how to fix this issue? Thanks.
for example:do I use the driver ( from As400 to SQL) correctly?
*****All of softwares are English version****
Server:
WIndows Server 2003 SP2 + SQL Server 2005 SP2
AS400:
V5R4
Client :
Winsows XP SP2 + SQL Server 2005 SP2
Client Access V5R4 Full Version.
*****All of softwares are English version****
Issue:
I have a file in the AS400 with Chinese characters and need to dowload to SQL Sever 2005 daily.
In the SQL Server, I created a database and table which collection is "SQL_Latin1_General_CP1_CI_AS", and I modified one of field which collection is from "SQL_Latin1_General_CP1_CI_AS" to "Chinese_Taiwan_Stroke_CS_AS" (( the filed data type is "nvarchar" and the length is 42).
That mean that field can display the Chinese characters correctly.
In the SSIS,
1.Craeted a OLE DB Source to get the data ( The field name is "CUST_CHINESE_NAME" and the length is 42) from AS400
2.Craete a Data Conversion to convert that field from "String" to "Unicode String[DT_WSTR]" (The new field name is "Copy of CUST_CHINESE_NAME")
3.Create a Data Conversion 1 to convert that field from "Unicode String[DT_WSTR]" to "String[DT_STR]" and code page is change to "950"(The new field name is "Copy of Copy of CUST_CHINESE_NAME")
4. Creatd a OLE DB Destination to get that convert data and input the SQL Server ( the filed data type is "nvarchar" and the length is 42).
When I execute that SSIS, I got the error message in the third step.
****************************************************************************************************************************
[Data Conversion 1 [521]] Error: Data conversion failed while converting column "Copy of CUST_CHINESE_NAME" (487) to column "Copy of Copy of CUST_CHINESE_NAME" (544). The conversion returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
[Data Conversion 1 [521]] Error: The "output column "Copy of Copy of CUST_CHINESE_NAME" (544)" failed because truncation occurred, and the truncation row disposition on "output column "Copy of Copy of CUST_CHINESE_NAME" (544)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
[DTS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Data Conversion 1" (521) failed with error code 0xC020902A. 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.
[DTS.Pipeline] Error: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC020902A. There may be error messages posted before this with more information on why the thread has exited.
****************************************************************************************************************************
March 10, 2008 at 3:28 pm
The error is saying that you are not allocating enough space in the DT_STR column "Copy of Copy of". Expand the length of the string. I would also recommend:
1. Renaming your derived columns so they make some sense.
2. Leave the data in unicode.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 10, 2008 at 11:06 pm
Jack, thanks.
But after I changed it, I got another error. Would you help me check it again? Thanks.
[DataReader Source [4470]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "DataReader Source" (4470)" failed because error code 0x80004002 occurred, and the error row disposition on "output column "PROD_SPECFICATION" (4626)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
March 11, 2008 at 6:32 am
If you change the error output to redirect row and place the attached script component in the path you can then output the error with the error description and the data to a table or file destination. This should help you find the problem.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply