Hi All - I have a package that has a loop. Inside this loop SSIS reads the contents of an Excel file then goes to a conditional split. The conditional split has logic to differentiate the data I want load from the headers. The data I want to load goes to a derived column transformation, then to my DB. The headers go to a multicast, and nothing more is done with that information. This runs without a hitch in BIDS. However, when I try to run in my production enviroment, no data is loaded. In my log files I see: Component "Receives NULLS and Headers - Does Nothing" (98) has been removed from the Data Flow task because its output is not used and its inputs either have no side effects or are not connected to outputs of other components. If the component is required, then the HasSideEffects property on at least one of its inputs should be set to true, or its output should be connected to something. My questions are: Where do you set the HasSideEffects property? Is this a good way to handle this situation or is there a more graceful way to get rid of the data I don't need? TIA - Gimcrack

Can I ask why you have the headers going to a MultiCast, if you're not doing anything with them? The conditional split does not have to have a destination for each defined condition Craig Bryden - Please mark correct answers

At the risk of sounding (being) dumb: If my conditional split hits a condition that it does not satisfy (aka it is one of my headers), are you saying that no actions is taken and it will just move to the next row? TIA - G

At this stage (I assume) you have a conditional split which has two outputs, one which identifies the data and another that identifies the header row. From the conditional spit, you connect to a Destination (or another transformation) at which time it asks you which "output" you want to use. Use the one that you have setup for the data. So basically, you can ignore the other output (the one you have created for the header row). I hope that clarifies it Craig Bryden - Please mark correct answers