SSIS package question

[pinkexpert]

Hi,

We have a SSIS package that is set up to load Data into our warehouse.This Package loads data to the ware house and processes the cubes once the dataware house load is complete.However there have been recent scenarios where empty cubes has been processesed due to some issues in the data load.However the package does not throw any error.It just processess empty cubes and some of the fact and Dim tables are empty.Can you provide a solution for this for example during the job execution before processing the cubes do Table count checks to determine if data build is successful or not.If there are any empty tables then send an error message and do not go ahead with the cube processing.



Help greatly appreciated

 

[xlbo]

How you do it really depends on how the dat is created and the reason why certain tables may be empty

If a table should never be empty then teh only real reason why it is will b to do with errors in the data flow loading

Do yuo have error routes in your data flows or are you simply setting the on error attribute to "ignore" ?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question