Max size in DataType Properties

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » Max size in DataType Properties - Advanced...

Max size in DataType Properties - Advanced Editor

Rate Topic

Display Mode

Topic Options

Author

Message

avishain

Posted Tuesday, January 29, 2013 8:28 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, June 06, 2013 12:23 AM
Points: 8, Visits: 40

Hello there,

ssis 2012.

is there a way to make this column more than 4'000?

the thing is, this field is Huge (contains text) and in my DB i set a filed with NVARCHAR(MAX)

while trying to use DT_WSTR(MAX) in the advanced editor i got an error... so i used

DT_WSTR(4000) but there are cases when truncation occurs and i loose some of the data.

how can i remove the limitation of the 4,000?

thanks

Post Attachments

Adv.jpg (4 views, 126.08 KB)

Post #1413080

opc.three

Posted Thursday, January 31, 2013 6:19 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:24 PM
Points: 6,826, Visits: 11,950

Not sure if XML Source has some limits, but you could try setting the output column to DT_NTEXT.

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1414067

« Prev Topic | Next Topic »

Permissions