I have a SQL agent job. The first step in the job is to run an SSIS package that loads data from a .txt file into a SQL table. The next steps in the job manipulate the data that was just loaded into the table until finally refreshing a table in excel with results. The problem I am having is that it seems the job does not wait for the SSIS package to complete before moving on to step 2 of job, so sometimes it works fine, and sometimes it starts the data manipulation before the data is loaded into the table and gives incorrect results. How can I get the job to wait for the SSIS package to complete before moving on?
See Question&Answers more detail:os