There is a datasource to connect source database.And in oledb destination control in SSIS having the option preview,once it is clicked we will get top 200

rows ,will come to know whether data is dumping or not.So when i clicked it is showing the data.But once it scheduled at some interval of time data is not transferring but schedulers showing success status.