Q. Task is running successfully but data is not loaded, Why?

Either your SQL Override is not reading any records, or your update stregy is not using the correct condition or check the task SQL Override and check the properties and make sure "Enable Test Load" is turned off.