CODEWITHSUNDEEP
sql-serverssisetlssis-2012msbi
Santhosh Reddy
Santhosh Reddy

Reputation: 15

DT_NTEXT to DT_STR Conversion

I have a field JSONStructure which has NT_TEXT Data Type and have to do a replace function on that.But, It looks like I cannot do a replace function on column having DT_NText DataType. I tried using Data conversion in SSIS But my JSONStructure can have more than 8000 characters and It is not working.

Can someone suggest me the best way to do it.

Thanks in Advance.

Upvotes: 0

Views: 456

Answers (1)

billinkc
billinkc

Reputation: 61259

I think you'll need to use a Script Component, acting as a Transformation, and you'll need to specify that the column is read/write and then use C#/VB.NET string methods to perform the string manipulation

Upvotes: 1

Related Questions