This project has moved and is read-only. For the latest updates, please go here.

Do the hashing algorithms support strings longer than 8000 chars?

Jan 24, 2013 at 4:09 PM

Do the hashing algorithms support strings longer than 8000 chars or Do multiple hashes need to be created?

                                            Morris

Jan 25, 2013 at 6:13 AM

G'day,

SSIS is limited to a string of 8000 characters for the DT_STR data type.

To do more than 8000 characters, you have to use the DT_TEXT or DT_NTEXT types.

DT_TEXT is limited to 2147483647 characters, and DT_NTEXT to 1073741823 characters.  To be honest, I have not run the component with data of that size...

Keith.

Marked as answer by kmartin on 7/8/2014 at 6:29 AM