Hi, I am trying to execute an SSIS package in SQL agent. Requirement is to check for a record in the log table and only if it exists then I should execute the SSIS package. For business reasons I cannot incorporate this logic into the SSIS package.
I need to implement this logic as a Step1 and Step2 in the SQL agent job.
Step1: Check if the record exists in the log table. Go to step2 only if a record exists.
Step2: Execute the SSIS package.
I know how to schedule an SSIS package in an agent job but need help with the logic above. THanks in advance for the suggestions.