NVarChar data type

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

Comments

  • Never mind. It fixed.
  • 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.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories