Howdy, Stranger!

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


NVarChar data type

lionblionb Member Posts: 1,688 ✭✭
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


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()


Any idea how to fix this problem? Again it is about Integration Services VBScript task


Sign In or Register to comment.