I have a web form that contains a button that when operated executes an SSIS package though an sql server agent on the same server on which the site is hosted. I am displaying the status of the SSIS package execution by querying sys activity tables for
the job and displaying the results. Ran into the issue of the job not being complete when querying the results so I want to put the datareader in a loop and query the tables until all 4 variables jobname, start date, end date and status are populated. After
the first read I close the reader and do the read again but get the exception "Invalid attempt to read when no data is present".
The section of code involved is below. Could someone kindly show me how I should be doing this? Thanks much for any help, Roscoe
sqlCmd.CommandText =Go to the complete details ...