CODEWITHSUNDEEP
ssis
Sreedhar
Sreedhar

Reputation: 30045

SSIS : Conversion DT_NTEXT to DT_WSTR

Whats the best way to convert DT_NTEXT to DT_WSTR in Derived Colum Transformation.

Regards

Upvotes: 10

Views: 54975

Answers (2)

Mitul Panchal
Mitul Panchal

Reputation: 632

Below are two solution for any types of data conversion in SSIS Package

  1. Use below link

    SQL Server and SSIS Data Types

  2. Mmanually convert that into Unicode string.

    (DT_WSTR,20)Columnname expression.

Upvotes: 1

Damir Sudarevic
Damir Sudarevic

Reputation: 22177

The problem here is that the max length of DT_NTEXT is 2^30 ~ 1.073 billion characters, while DT_WSTR max length is 4000 characters.

If all your fields are less than 4000, try Data Conversion Transformation and it may only raise a warning at design time. You would add this before of after the Derived Column Transformation.

Upvotes: 16

Related Questions