BPC use nvarchar for the properties. A s Microsoft describe:
"nvarchar [ ( n | max ) ]
Variable-length Unicode string data.n defines the string length and can be a value from 1 through 4,000.maxindicates that the maximum storage size is 2^31-1 bytes (2 GB)."
so you can specify until 4000 chars or use MAX(=(2 ^ 31 - 1) / 2 = 1'037'741'823 double-byte characters) but I don't know if BPC supports this option, I never use this.
We got an issue if have more then 255 characters in one property. The length for the property is set to 500. Processing the dimension fails and we get this error message in tblLog.
==============[System Exception Tracing]============== [System Name] : ManageDimension [Message Type] : ErrorMessage [Job Name] : clsMakeDimension : varStratMakeDimension [DateTime] : 4/10/2013 4:17:00 PM [UserId] : MEDIA\frekyl [Exception] DetailMsg : {, Microsoft Data Transformation Services (DTS) Data Pump, Data for source column 7 ('Kommentar') is too large for the specified buffer size., Microsoft Data Transformation Services (DTS) Data Pump, Data for source column 7 ('Kommentar') is too large for the specified buffer size. Source: InsertExcelToDb Msg: , Microsoft Data Transformation Services (DTS) Data Pump, Data for source column 7 ('Kommentar') is too large for the specified buffer size., Microsoft Data Transformation Services (DTS) Data Pump, Data for source column 7 ('Kommentar') is too large for the specified buffer size. } ==============[System Exception Tracing End ]==============
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.