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. 

Environment

 Blackbaud CRM
 4.0

Was this article helpful?