• There is solution based on the third-party commercial CozyRoc SSIS+ library. CozyRoc has implemented data flow destination script, which creates memory-efficient range dictionary object. The dictionary object can then be used in CozyRoc Lookup Plus component. For more information and demonstration how to use the script, check here:

    http://www.cozyroc.com/script/range-dictionary-destination

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/