Hi , I will try to be short and clear. We have SSIS job to transfer data from Oracle to SQL Server that runs daily in the morning at 9:00 am. This package should run after the jobs on the Oracle database are complete,That is as soon as my Oracle database gets data my SSIS package (Moving Data from Oracle to SQL Server) should start. I do not know what jobs are running on the Oracle,The only thing I have is a Query that Shows the Status of the jobs,If my Query shows that Status of all the Oracle jobs are Finished then I can run my SSIS package for dataflow between oracle and SQL Server. The Query that is in PL-SQL returns 2 Columns and 40 rows: Status Column and the Name of the job Column. Any Ideas How we can do this? My approach: I wrote a package having a Execute SQL Task and it executes my Oracle query and populates the result set into a variable in SSIS,but I dont know how to use the result set and Check the condition for if status = finished ,then execute my package i.e Oracle to SQL. Hope you all understood. Pls Help Me Regarding This. Anand.