Data flow task executing successfully but not writing any rows to Excel file

I am working on SSIS package that is fetching data from SQL server and inserting into Excel file… in Data Flow Task i’ve used OLE Db source and Excel destination.

After configuring OLE Db source i can preview the resulting row and even data flow task executing successfully without giving any error.. but not inserting any row..

Answer

Well fortunately i found the answer,I did two things..

1. I just deleted the old Data Flow Task on which i have tried so many different settings and parameters… and Build the Data Flow Task all over again…

2. In SQL query i’d wrote the Fully qualified name instead of ‘Use Database’ Statement.

Hope this will help someone..