Search code examples
sqlsql-serversql-server-2008informaticainformatica-powercenter

Insert into SQL Server has failed due to invalid data length error

Column of type nvarchar(max) in a SQL Server table throws an error when we try to insert a value that is greater than 5000 characters through Informatica.

The error is:

Invalid data length or metadata length

Data load succeeds when we insert value that has lesser than 5000 characters.

What could be the reason for this failure?

Solution

  • Refer to below given article.

    https://kb.informatica.com/solution/23/Pages/55/379764.aspx