SSAS cube processing error about column binding

Question

This is an error message I get after processing an SSIS Cube

Errors in the back-end database access module. The size specified for a binding was too small, resulting in one or more column values being truncated.

However, it gives me no indication of what column binding is too small.

How do I debug this?

Answer 1

This error message has been driving me crazy for hours. I already found which column has increased its length and updated the data table in the source which was now showing the right length. But the error just kept popping up. Turns out, that field was used in a fact-to-dimension link on Dimension Usage tab of the cube. And when you refresh the source, the binding created for that link does not refresh. The fix is to remove (change relationship type to 'No Relationship') and re-create that link.

Upd: Since that answer seems to be still relevant, I thought I'd add a screenshot showing the area where you can encounter this problem. If for whatever reason you are using a string for Dimension-to-Fact link it can be affected by the increased size. And the solution is described above. This is additional to the problem with Key, Name, and Value Columns on the Dimension Attribute.

Answer 2

ESC is correct. Install the BIDS Helper from CodePlex. Right click on the Dimensions folder and run the Data Discrepancy Check.

Dimension Data Type Discrepancy Check

This fixed my issue.