Control Charting??

I have a need to provide a control-chart-like appearance to the user
community.
Basically I need to track costs over a period of months against a
previous year (or some historical range) and show where the current
costs are tracking above/below the corresponding historical values.
I was thinking about using a standard line chart and somehow
incorporate two horizontazl lines (one high/one low) within the chart
area (don't know if this is possible with SRS). So, far I'm still
trying to figure out the SQL Query...
Has anyone tried to do a control-chart (simulate) or... is there a
better approach?
Thanks
GlennIf you just want constant values for the high/low horizontal lines, you can
easily achieve it by just adding a new "value" in the chart properties
dialog / "Data" tab. You would use e.g. =100 as value expression for this
new series value.
If you have historical data from a query, you would add e.g. a series
grouping based on the date values, e.g. =Year(Fields!SomeDateField.Value).
Therefore your values will be automatically grouped per year and shown as
independent series in the chart.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Glenn Owens" <gowens@.nixonpeabody.com> wrote in message
news:bc4291aa.0408131137.7653fdb5@.posting.google.com...
> I have a need to provide a control-chart-like appearance to the user
> community.
> Basically I need to track costs over a period of months against a
> previous year (or some historical range) and show where the current
> costs are tracking above/below the corresponding historical values.
> I was thinking about using a standard line chart and somehow
> incorporate two horizontazl lines (one high/one low) within the chart
> area (don't know if this is possible with SRS). So, far I'm still
> trying to figure out the SQL Query...
> Has anyone tried to do a control-chart (simulate) or... is there a
> better approach?
> Thanks
> Glenn

Consuming Error Output from a Derived column component

Hi,

I have created a program that imports a csv into the sql server. but during that import I need to track all the errors that occured for some malformed rows. I think I need to use the error output collection of the dataflow components to track the errors. I figured out that every dataflow component has a error output collection along with the data output collection. I want to write those error outputs into a separete database. So, I have created a SQL server data destination component and created a path between derived columns error output and it input collection. But it is not working as expected. can any body help on this?

or can anyone give me any example how to use/handle error output collection in SSIS?

I will appreciate all kind of suggestions.

thanks

Why is it not working? Are you receiving any errors? What are those errors?|||

Give more details...

What is the error?