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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.