I have a Data flow task which looks in a table and then uses a row count to save the number of rows into a variable. This variable is used later to decide whether to perform an action.
My problem is that when I run this data flow I get a warning because the single column on the output is not used later in the Data flow. I have tried removing all of the columns from the input but that causes an error.
The warning I get is shown below:
The output column "" (48) on output "OLE DB Source Output" (21) and component "" (11) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Is there a way to suppress this warning?