Hi

Sorry for the late reply.I have multiple jobs schedulers which will all the schedulers for every 15minutes,so that data will be transferred from cache database to sql db.The query for returning the data is

select * from applicationstat where "timestamp" > dateadd(minutes, -15 ,getdate()) and "timestamp"< getdate()

So it is going to retrieve last 15minutes data.So all the schedulers are running to retrieve each table from the same cache database.Now the problem is sometimes data is missing even the schedulers are showing success status in schedulers history.So iam checking that source database table is having the data because there is an option in SSIS oledb destination control having preview option,when ever i clicked on it,we can ablse to see the data.Even I set the logging there is no error in log files.Please tell me what i hv to check now.

Regards

Srinivas