I have a DataFlow that selects the distinct Date into a recordset variable. Based on the Date variable, I have a ForEach Loop container that reads the Date variable. Inside the ForEach Loop container, I have another DataFlow that create a Store cache. In the
Store cache data flow, I added a new column based on the Date variable and then create a cache.
Now my question is, what is the best approach to handle null Date variable? or Is it possible to create an empty Store cache? I was thinking to create a Store cache even it is empty so that the other DataFlow object can be processed.
View Complete Post