May 1, 2012 at 8:43 am
We have ssis job on sql server 2008 which i s failing with the below error.
This error seems to be either truncation or bad character.But am not under standing were i have to change this and were that flat file is located.
I dont know much about SSIS and can any one help me out here.
Can any one help me here.
xecuted as user: 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: 11:00:37 PM Error: 2012-04-30 23:00:42.02 Code: 0xC02020A1 Source: DTSTask_Task_1 Text File (Destination) [16] Description: Data conversion failed. The data conversion for column "ACT_REC_ID" 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-04-30 23:00:42.02 Code: 0xC02020A0 Source: DTSTask__1 Text File (Destination) [16] Description: Cannot copy or convert flat file data for column "ACT_REC_ID". End Error Error: 2012-04-30 23:00:42.02 Code: 0xC0047022 Source: DTSTask__1 SSIS.Pipeline Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Text File (Destination)" (16) failed with error code 0xC02020A0 while processing input "Flat File Destination Input" (17). 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 DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:00:37 PM Finished: 11:00:42 PM Elapsed: 4.359 seconds. The package execution failed. The step failed.
May 1, 2012 at 8:44 am
The error message says column ACT_REC_ID is longer in the source than in the destination, and is hitting a truncation error.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 1, 2012 at 8:58 am
THanks for reply,
how to see where the source and distination files are located
May 2, 2012 at 6:17 am
The connections in the SSIS package will have that. Double-click them. The connections are usually in a window at the bottom of the screen in BIDS.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 2, 2012 at 8:53 am
Thanks for help,
I was able to connect the package.
Can you please tell me where have to change or modify the column size.
can you plz guide me the steps
Many THANKS.
May 2, 2012 at 9:31 am
bala2 (5/2/2012)
Thanks for help,I was able to connect the package.
Can you please tell me where have to change or modify the column size.
can you plz guide me the steps
Many THANKS.
You will need to change this in the physical destination table in your database
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 2, 2012 at 9:42 am
I could see the source table in database for that cloumn is 30( vachar) and on the flat file in siss it is showing as 255.
ssis-package-dataflow-flatfile (doubleclick) there it is showing as cloumn len as 255.
can i change here and save it.
Plz guide me.
May 3, 2012 at 4:02 am
Any guidenc PLZ
May 3, 2012 at 8:41 am
Are you going from the table to a flat file?
If so, then it's less likely to be truncation and more likely to be an incompatible file format. Are you exporting data from an NVARCHAR/NCHAR column to an ASCII-format text file? Does the table contain extended-character-set data, like Japanese characters or that kind of thing?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 3, 2012 at 9:59 am
Yes we are going from table to flat file.
the column is nvarchar(30) --table.This table does not contain any extended-character-set data,
In flatfile (On SSISdoule click Textfile Destination ---Flat Filedestination cnnection mannager -advance tab )
datatype Unicode string [DT_WSTR]--255(lenth)
Plz advise.
May 4, 2012 at 7:03 am
I'd have to actually see your system, your database, and your data to take this any further. I'm not in a position to do that, but I'm sure you can get a local recruiter to recommend a contractor to you on the subject.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply