Post reply

NVARCHAR(MAX) TO NText

  • January 18, 2013 at 9:23 am

    #288181

    Hi, the problem I'm having is when I'm passing NVARCHAR(MAX) output parameter from a stored procedure to a SSIS derived column with NTEXT data type

    we get an empty string. It was working before when the derived column transformation was (DT_WSTR, 4000) which is the equivalent of NVARCHAR(4000). NTEXT is supposed to be the ssis equivalent to NVARCHAR(MAX)

    but we need to change it because the values we're getting are more than 4000 characters

    Thanks.

  • January 19, 2013 at 11:15 am

    #1578974

    Which version of SSIS?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • January 19, 2013 at 3:28 pm

    #1578996

    2008 R2

  • January 20, 2013 at 7:21 am

    #1579020

    When you say "output parameter" I am assuming you are capturing that using an Execute SQL Task. Are you using OLE DB or ADO.NET? Can you show some screenshots of the Execute SQL Task property pages?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply