• Thanks for replay, i have one more doubt ...

    Is there any limitation for file size through query not from SSIS package.

    it gives error message as

    "server is not responding to dump the excel file" for 2.5 MB file and it works for 1.5 Mb file.