I use SSIS to perform ETL process and some times the client sends new or unknown files. I do have a table that captures the unknown file information and have a SP that checks the table at the conclusion of the process. How can I execute the previous package only if there is a unknown file? I thought that I would execute a SQL TASK basically doing a coun(*) for any files that appeared today and if > 0 it would flow through the SSIS package that sends me the list of file. If the value is = 0 then don't execute the next package.
Have I confused you enough?