Share via

Unexpected data truncated

Sin X 60 Reputation points
2025-01-23T08:31:59.5866667+00:00

I'm loading data from Excel to sql table.

The address column has been truncated unexpected Which cause the data lost.

However other column is fine with all data

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,491 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,664 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 41,291 Reputation points
    2025-01-23T09:21:01.1+00:00

    Hi @Sin X，

    If possible, could you please share with us your design sample or you are loading data directly?

    First please confirm the length of the column is set correctly in Advanced Editor.

    User's image

    Please also check when you preview the data, will the data lose or not.

    Also, you may redirect the error rows to see what happened during the process.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 46,281 Reputation points
    2025-01-23T08:35:27.7233333+00:00

    That's really to less of information; no one can guess what you have (implemented), source data and destination table.

    By default Excel columns have a size/data type of nvarchar(255).

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.