nikithanaidu,

Since You are exporting to Excel, the "Opening a rowset for "Results" failed"

indicates the receiving Excel File does not exist or does not have a worksheet with name "Results".

Verify the Excel exists or is created during package run.

(Excel Connection Manager controls the creation of Excel file).

If "Results" worksheet does not exist,

you can add a create an "Execute Sql Task" to create the worksheet.

I would use the SSIS import export wizard with the same input table and excel output.

You can compare the converted SSIS with one created by Wizard.