The key is to find out which attribute of which dimension is giving the error:
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.
Usually when through SQL Server agent, it will be the first one.
Using SSMS do the processing and navigate to the dimension processing errors and find out which attribute of which dimension is this error associated with.
Once we know that we should be able to fix it by:
- Increasing the value of the property called DataSize for the attribute under both NameColumn and KeyColumns.
- Associate if any of the NameColumn or KeyColumns, is missing