NVarChar data type

lionb

Foloowing code works perfectrly in VB.NET. However, when I tried to use it as VBScript with Integration Services, I got Error message [color=Red]'String or binary data would be truncated. The statement has been terminated'[/color]. It is about NVarChar data type (see blue line of code).

SQL Server 2008 Parameter

@Body NVARCHAR(MAX)

[code]
Dim cmdInsert = New SqlClient.SqlCommand("usp_INSERT_UPDATE_ARTICLE_DATA_MIGRATION", insertConn)
cmdInsert.CommandType = CommandType.StoredProcedure

cmdInsert.Parameters.Add("@Title", SqlDbType.VarChar, 4000).Value = "testing"
[color=Blue]cmdInsert.Parameters.Add("@Body", SqlDbType.NVarChar).Value = stringAdd[/color]
cmdInsert.Parameters.Add("@ArticleDate", SqlDbType.DateTime).Value = Now()

cmdInsert.ExecuteNonQuery()

cmdInsert.Dispose()
Any idea how to fix this problem? Again it is about Integration Services VBScript task

lionb

Never mind. It fixed.

James

Have you tried explicitly specifying the max in your parameter declaration?

@Body nvarchar(4000)

I had an issue with this datatype being declared as "MAX" because of a legacy issue.