truncation may occur due to inserting data from data flow column in ssis

Question

HI ,

I have normal task in ssis package only taking the source data from excel source and go to target ole db target but i got the warning can you help me what can i do her is some screenshot :

the below Are destination/target (show advanced editor)

kindly help me

Answer 1

Hi @AnamikaDas-0462,

The waring is incomplete, suppose that it tells you such as:

Warning: Truncation may occur due to inserting data from data flow column "Acqxxx" with a length of 255 to database column "Acqxxx" with a length of 50.

In order to remove this warning message from SSIS solution, make sure datatype length of the source column should be equal to the datatype length of the destination column.

Change the destination column length to 255 for a try or change the data source length to 50.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Truncation may occur

That means you try to insert large data into a destination, then it's defined for the destination column.
Your source is nvarchar with max size 255 and the destination column is smaller then 255 characters.

Answer 3

Your screen prints indicated your target "Acquisition Item" is an nvarchar(50).

As a default all fields from Excel are returned as nvarchar(255). The simplest answer is to use a data conversion to truncate the field to nvarchar(50) before the insert.

Answer 4

Hi @AnamikaDas-0462,

We could not see the complete error message, you may copy it as text for us to do more analysis,

For the warning you may increase the MaximumErrorCount, the location is shown below.