I have an SSIS package; the same logic could be used for a DTS package that I need to see if a CSV file is on the SQL server. Then based on if the file is there on the server (the same server that is running the query):
If the file is there, then I need the SSIS package to go to the next step.
If the file is not there, go to a different step.
I do not want to place the next step in the same step that looks for the file. Thanks!