I have a spoon transformation that runs perfectly fine in spoon. It generates a text file with a number of records in it (5224 records).
However, recently, when I try to use that transformation inside of report-designer I get very different results.
For instance, if I use the text file output step as my input I see zero records. As I trace the steps backwards earlier steps have more than previous steps but they all seem to have much fewer records than what I get in spoon.
Why am I seeing fewer records inside of report designer than spoon?
Report-designer using Spoon did seem to work last week. I've been tweaking my Spoon transformation since then and I thought that might invalidate report designers connection with it. So I tried starting a new report that connected to the spoon transformation, but this did not help.