Truncation may occur due to inserting data

Question

I recently changed the flat file source in the data flow task. Following that change, I am noticing below error for most of the columns and SSIS package no longer executes. Can someone please let me know what might be going wrong?

Also I see these messages in the job history: Description: Truncation may occur due to inserting data from data flow column "HomePhone" with a length of 50 to database column "HOMEPHONE" with a length of 15.

Thanks.

Answer 1

Hi @Mike Harris ,

1.Please add length of column "HomePhone" using the following sql query in SSMS:
ALTER TABLE [TableName] ALTER COLUMN [ColumnName] VARCHAR (50);

2.Or create new table with the length of cloumn "HomePhone" as 50.

Best Regards,
Mona

---

If the answer is helpful, please click "Accept Answer" and upvote it.
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

When you changed the connection manager - it defaulted to string 50 for all columns. You need to go into the connection manager - the advanced page and change the data type and length of every column to match the columns in the table.

If there are a lot of columns - you could create a new connection manager as a source from the database table. Once created it should have all of the fields and correct data types. You can then delete the source in the data flow leaving the connection manager and use that connection manager as the source from the file. You may need to move things around if the column order isn't the same.