May 29, 2012 at 12:33 am
HI,
Can any once help me .
we have ssis package which is loading the data form flat file to table.
It is failing with below error.
The "output column "Col002" (30)" failed because truncation occurred, and the truncation row disposition on "output column "Col002" (30)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. End Error Error: 2012-05-29 05:58:18.38 Code: 0xC0202092 Source: DTSTask_DTSDataPumpTask_1 Flat File Source [1] Description: An error occurred while processing file "C:\ user.txt" on data row 1. End Error Error: 2012-05-29 05:58:18.38 Code: 0xC0047038 Source: DTSTask_DTSDataPumpTask_1 SSIS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Flat File Source" (1) returned error code 0xC0202092. 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: 5:58:16 AM Finished: 5:58:18 AM Elapsed: 1.406 seconds. The package execution failed. The step failed.
Please guide me to resolve the error.
Thanks.........
May 29, 2012 at 1:00 am
check this out:Col002" (30)" failed because truncation occurred, you meed need add more space for this column.
May 29, 2012 at 1:30 am
Thanks reply,
Can you please clarify were to check the space of the column and were i have to incease the column.
we are using package to load the data form flatfile to database table.
Please guide me...
May 29, 2012 at 1:32 am
You should incease the column, such as from varchar(10) to varchar(50), sorry to make you confused. 🙂
May 29, 2012 at 1:55 am
Manny thanks..
1)I could see in the database table the .
column size is char(1)--------
2)advance editor for ole db destionation -----input.output tab---external columns
-----data type :dt_str
lenght--1
3)on flat file ------flat file connectionmannger editor-----advance----col002(column name)
------it is showing outputcolumnwidth as '0'
datatype as dt_str
Can please confirm were i have change the column size in
database table or OLBD destinaton or flatfile...
May 29, 2012 at 2:05 am
What is the longest string in column 2 of your text file?
John
May 29, 2012 at 2:19 am
Many thanks for reply,
Length of cloumn2 in flatfile is 255
May 29, 2012 at 2:22 am
There's your problem, then. You're trying to fit 255 characters in a char(1) column. The column in your table needs to be varchar(255) and the columns in your data flow need to be a similar size.
John
May 29, 2012 at 4:29 am
Hi
i have changed the cloum len to varchar(255) on the table and i have exctued the job but still getting the same error.
Message
SQLagent. Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:23:32 AM Error: 2012-05-29 10:23:33.59 Code: 0xC02020A1 Source: DTSTask_DTSDataPumpTask_1 Flat File Source [1] Description: Data conversion failed. The data conversion for column "Col002" 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: 2012-05-29 10:23:33.59 Code: 0xC020902A Source: DTSTask_DTSDataPumpTask_1 Flat File Source [1] Description: The "output column "Col002" (30)" failed because truncation occurred, and the truncation row disposition on "output column "Col002" (30)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. End Error Error: 2012-05-29 10:23:33.59 Code: 0xC0202092 Source: DTSTask_DTSDataPumpTask_1 Flat File Source [1] Description: An error occurred while processing file "c:\\user.txt" on data row 1. End Error Error: 2012-05-29 10:23:33.59 Code: 0xC0047038 Source: DTSTask_DTSDataPumpTask_1 SSIS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Flat File Source" (1) returned error code 0xC0202092. 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: 10:23:32 AM Finished: 10:23:33 AM Elapsed: 1.141 seconds. The package execution failed. The step failed.
"
i have checked the The column in table varchar(255) and the columns in your data flow (OLDB-destiantion) is DT_STR, lenthe --255
please suggest me.
May 29, 2012 at 4:40 am
2)advance editor for ole db destionation -----input.output tab---external columns
-----data type :dt_str
lenght--1
Did you change this as well? You need to go through your whole data flow and make sure that all the data types are correct.
John
May 29, 2012 at 4:49 am
yes ,
i have changed that too.
Now it showing as
advance editor for ole db destionation -----input.output tab---external columns
-----data type :dt_str
lenght- 255
Thanks...
May 29, 2012 at 4:54 am
Right, if it's still not working then run the package in Visual Studio and watch for where it fails. You can then concentrate your investigation in the correct place. You may find it useful to set up a Data Viewer to help you see what's going on. There's plenty about that in the documenation and on the web in general. Good luck!
John
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply