Words in SmartField table get cut off in new CRM 4.0

there is a 99-character limit on SmartFields in the Data warehouse


Steps to Duplicate

1. Create a constituent smart field with a text datatype with at least one value over 100 characters.

2. Run ETL and notice how the character values are cutoff after 99. 


 Blackbaud CRM

Was this article helpful?