Skip to Content
0
Former Member
May 17, 2010 at 02:08 AM

Data package error handling

26 Views

Hi there,

Say I have a data package that:

1. Clear a subset of data defined by parameters ENTITY, CATEGORY, TIME sent through the Excel data manager

2. Import data from a table for the same selected ENTITY, CATEGORY, TIME

To clear the data subset in 1., I use the typical EXPORT ZERO and LOAD ZERO method. However, when the selected ENTITY, CATEGORY and TIME have no record yet in any of the 3 fact tables, the LOAD CUBE task fails. I forced it to "Success" using the ForceExecutionResult in SSIS but it causes the following BPC task to fail as well. If I disable the LOAD ZERO, the subsequent BPC tasks executes successfully.

How do we handle this LOAD ZERO thingy when there is no actual data in the database?

Thanks

Regis