How can I add non additive measure to destination database RRS feed

  • Question

  • I have 3 non additive measure that were calculated in derived column transformation.Now, I did the aggregate transofrmation to sum up my additive measure as the the last 3 I didnt put them in the aggregate but when I was trying to insert my measure to fact table those last 3 didn't show up ! How to insert them in the fact table should I use another transofrmation and what is it ?

    Sunday, July 22, 2012 7:24 PM


  • If you didn't add those 3 measures in the aggregate then they won't be available after the aggregate because it is a Fully-blocking/Asynchronous component.
    I can't see how you calculate them, but sum them in the aggregate or calculate them after the aggregate...

    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

    • Proposed as answer by Eileen Zhao Friday, July 27, 2012 5:21 AM
    • Marked as answer by Eileen Zhao Monday, July 30, 2012 2:03 AM
    Monday, July 23, 2012 6:26 AM