Creating Error Output for Custom Components

Hi,

I have a 2 custom components - source and destination.

I want to create an error output for each, to allow the users of my component to handle errors the way they choose.

I only found a property in IDTSOuptut90 named isErrorOut - a boolean property indicating whether this output is an error output or not.

Does anyone have additional documentation / articles / code samples regarding how to really populate the rows in the error output?

Thanks

You add the output in ProvideComponentProperties, as others, and that property is pretty much the key-

// Error Output
IDTSOutput90 outError = ComponentMetaData.OutputCollection.New();
outError.Name = ErrorOutput;
outError.Description = "Error output for rows that caused an unexpected error.";
outError.SynchronousInputID = inp.ID;
outError.ExclusionGroup = 1;
outError.IsErrorOut = true;

In ProcessInput you would then direct rows to thje normal output or the error output.

int iError = ComponentMetaData.OutputCollection[ErrorOutput].ID;
buffer.DirectErrorRow(iError, 0, buffer.CurrentRow);

I don’t believe there are no samples in the recent batch on Microsoft.com/downloads/ and from memory I’m sure the Source sample that ships with the product includes error output usage.

Creating Dimensions

I have a cube with a dimension 'Destination', that has the follown herarchy.

Country -> State -> City.

As measure I have Number of transactions.

When I browse the cube I can get the total transactions if I expand all the levels, but If I just want o have number of transactions by state or country the cube is no creating totals by those levels. Even in the cube when I expand all levels (including city), there are not totals by state and country. What I am missing?

You can email me to jzuluaga@.msn.com or jzuluaga@.quisqueyana.com

Thanks

Juan,

What are you using to browse the cube?

Steve

|||

Check the calculations of the cube and make sure that it contains the CALCULATE command. This command is always included by default, but if it is deleted accidentally, then you will only get leaf level data as this command is what instructs the server to aggregate data up from the lowest levels up to the higher levels.