2

Resolved

Status Output is Incorrect

description

The output status message is not putting the correct value for deleted records. It is using the counter for new records.
 
Line 4994 in the PostExecute Method:
            SSISUtility.Messaging.PostInformation(ComponentMetaData, "Input rows processed: "
                + this._existingDimensionInputCache.CountRows.ToString() + " Existing Dimension, "
                + this._specialMembersInputCache.CountRows.ToString() + " Special Members, "
                + this._sourceSystemInputCache.CountRows.ToString() + " Source System");
            SSISUtility.Messaging.PostInformation(ComponentMetaData, "Rows output: "
                + this._counterOutputUnchanged.ToString() + " Unchanged, "
                + this._counterOutputNew.ToString() + " New, "
                + this._counterOutputNew.ToString() + " Deleted, "
                + this._counterOutputSCD1Update.ToString() + " SCD1, "
                + this._counterOutputSCD2Expired.ToString() + " SCD2 Expired, "
                + this._counterOutputSCD2New.ToString() + " SCD2 New, "
                + this._counterOutputInvalid.ToString() + " Invalid Input");

comments

toddmcdermid wrote Jun 18, 2010 at 8:21 PM

Fantastic - thanks for all the info. I've updated my local source, it'll make it up here eventually...

toddmcdermid wrote Jun 18, 2010 at 8:24 PM

Fantastic - thanks for all the info. I've updated my local source, it'll make it up here eventually...

toddmcdermid wrote Jun 18, 2010 at 8:27 PM

Fantastic - thanks for all the info. I've updated my local source, it'll make it up here eventually...

toddmcdermid wrote Jun 18, 2010 at 8:27 PM

Fantastic - thanks for all the info. I've updated my local source, it'll make it up here eventually...