Did you tried to create a Shared Cache file in the SSIS? by shared I mean that a cache file which you can write on it multiple times through package execution. When you use a Cache Transform in data flow task and write data stream on it, if you try to fill it again in Read more about Shared Cache File – Re Use Cache File – SSIS[…]