SSIS Data Type for VARCHAR(MAX)

Question

Hi, I have one of the column to store 32700 data length as VARCHAR, So I created in table for this column as VARCHAR(MAX). How to configure in SSIS advanced editor for this type of data so there is no truncation? Anyone can help. Appreciate it.

Answer 1

Hi @jn93 ,

You can set the data type of the column as textstream[DT_TEXT].

DT_TEXT could contain an ANSI/MBCS character string with a maximum length of 2^31-1 (2,147,483,647) characters.

integration-services-data-types

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.