Hi, I have a Excel Spread sheet which has a column name JURISDICTION. It has Values like 1275,1276,1278 and some rows contains character "Other".. when i'm transforming this to Sql Table which has a column name "JurisID" ( Data type -Char(4))... the numeric values are inserting but the row which has "Other" values is not inserting..it gives error like below.. [Derived Column [20]] Error: The "component "Derived Column" (20)" failed because truncation occurred, and the truncation row disposition on "output column "JurisID" (286)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. [Excel Source [1]] Error: Setting the end of rowset for the buffer failed with error code 0xC0047020. [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Derived Column" (20) failed with error code 0xC020902A while processing input "Derived Column Input" (21). 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. [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Excel Source" (1) returned error code 0xC0209017. 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. Thanks for any help or information

i'm modifying the Data type to string in the Derived Column. but when the process starts executing, it gives error when the flow comes to derived column like the error above mentioned...

i'm modifying the Data type to string in the Derived Column. but when the process starts executing, it gives error when the flow comes to derived column like the error above mentioned... You don't need to change it in the dataflow, you need to change the column datatype in the SQL Server destination table. The string "Other" doesn't fit in a char(4) column. That's why you get a truncation error, because SSIS doesn't want to insert "Othe".MCTS, MCITP - Please mark posts as answered where appropriate. Answer #1: Have you tried turning it off and on again? Answer #2: It depends...

why it doesn't insert the characters...?

Show us please how you set up your Derived Column Transformation. Based on what I see the error is indeed in the data length, you need to enlarge it wide enough. See "Data type -Char(4)" vs. "Other". The lngth of "Other" is 5, not 4.Arthur My Blog

You have to change the data type length of the column JurisID Char(5) as "other" has the length of 5. Also make sure for any other values with different length and then modify the column length accordingly.

Show us please how you set up your Derived Column Transformation. Based on what I see the error is indeed in the data length, you need to enlarge it wide enough. See "Data type -Char(4)" vs. "Other". The lngth of "Other" is 5, not 4.Arthur My Blog

In my derived Column i put the length as 10...but it goes into the destination as null.....why it is not taking the characters into the destination column(char datatype)

Hi Praksh.R, According to your description, I suspect that there have null value in derived Column, please refer to the following links: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/62c8d03a-7f4d-4c33-b39f-7c5b7928b26a/ http://www.bidn.com/blogs/DonnyJohns/ssas/1919/handling-null-or-implied-null-values-in-an-ssis-derived-column If you have any question, please feel free to ask. Thanks, Eileen