OK, that means there's something in your Execute SQL Task that is not working properly. Can you post details about that task?
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices