Error: Data conversion failed. The data conversion for column ENABLED" returned status value 2 - when running ETL refresh

ETL refresh fails with:
Error: 2013-11-11 10:36:32.95
   Code: 0xC02020A1
   Source: Get package details Load package dependencies [47]
   Description: Data conversion failed. The data conversion for column "ENABLED" returned status value 2 and status text "The value could not be converted because of a potential loss of data.".
End Error
Error: 2013-11-11 10:36:32.95
   Code: 0xC0209029
   Source: Get package details Load package dependencies [47]
   Description: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "output column "ENABLED" (111)" failed because error code 0xC0209084 occurred, and the error row disposition on "output column "ENABLED" (111)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
End Error
For CRM version 3.0 and higher the database server must be on at least SP2 of SQL Server 2008.  System requirements can be found on the Blackbaud website at: https://www.blackbaud.com/nonprofit-resources/system-requirements.aspx

Environment

 3.0.516

Was this article helpful?