Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

NVARCHAR(MAX) TO NText Expand / Collapse
Author
Message
Posted Friday, January 18, 2013 9:23 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 1:52 PM
Points: 97, Visits: 317
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.
Post #1408971
Posted Saturday, January 19, 2013 11:15 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:45 PM
Points: 7,094, Visits: 12,582
Which version of SSIS?

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1409216
Posted Saturday, January 19, 2013 3:28 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 1:52 PM
Points: 97, Visits: 317
2008 R2
Post #1409241
Posted Sunday, January 20, 2013 7:21 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:45 PM
Points: 7,094, Visits: 12,582
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
Post #1409273
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse