Error during incremental processing of dimension

I have an integration services package that includes a data flow transformation that does an incremental processing for a dimension. The task executes successfully with a small amount of records in the data source query. However, when I attempt to process the large set, I get the following errors:

[Dimension Processing [1192]] Error: Parser: An error occurred during pipeline processing.
[Dimension Processing [1192]] Error: Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
[Dimension Processing [1192]] Error: Errors in the OLAP storage engine: An error occurred while the 'Last Name' attribute of the 'Consumer' dimension from the 'DataWarehouseOLAP' database was being processed.
[Dimension Processing [1192]] Error: File system error: The record ID is incorrect. Physical file: . Logical file: .
[Dimension Processing [1192]] Error: Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
[Dimension Processing [1192]] Error: Errors in the OLAP storage engine: An error occurred while the 'Email Address' attribute of the 'Consumer' dimension from the 'DataWarehouseOLAP' database was being processed.
[Dimension Processing [1192]] Error: File system error: The record ID is incorrect. Physical file: . Logical file: .
[DTS.Pipeline] Error: The ProcessInput method on component "Dimension Processing" (1192) failed with error code 0x80004005. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.
[DTS.Pipeline] Error: Thread "WorkThread0" has exited with error code 0x80004005.
-

I am trying to figure out more information about these errors, but cannot figure out what the problem is. Can someone point me in the right direction?

Clayton

We just encountered the same error. Did you figure out what it was?|||No I did not. I am still stuck on it. I will let you know if I do.|||

Please log your situation in http://connect.microsoft.com/sql. If you willing to share your data to troubleshoot, make sure you provide your contact information.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi,

I am facing the same issue. Can you please let me know if there is a solution for resloving this ?

Regards,

Dinesh Reddy N Y

|||

Sounds like you're exceeding the 4 GB limit for string stores. Do you have an attribute with a string key?