Click here to Skip to main content
14,085,623 members
Rate this:
 
Please Sign up or sign in to vote.
See more:
Source: Get Data [2289] Description: There was an error with output column "cust_store" (2560) on output "OLE DB Source Output" (2299). The column status returned was: "Text was truncated or one or more characters had no match in the target code page.". End Error Error: 2014-03-17 11:01:52.79 Code: 0xC020902A Source: Get Data [2289] Description: The "output column "cust_store" (2560)" failed because truncation occurred, and the truncation row disposition on "output column "cust_store" (2560)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. End Error Error: 2014-03-17 11:01:52.79 Code: 0xC0047038 Source: Get Data Descriptio... The package execution fa... The step failed.
Posted

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

ull get this error when the size of the column exceed.

eg: in db u have a column varchar(50)
and in ur package u have varchar(40)
then u will get this error

or

eg: in db u have a column varchar(50)
and in ur package u have varchar(50)
and in ur flat file or sql source may have more than 50 then ull get this error

Solution: all ull have to do is increase the size of the column..
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Cookies | Terms of Service
Web01 | 2.8.190518.1 | Last Updated 18 Mar 2014
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100