visu.viswanath (7/8/2014)
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.
Is that the actual error message?
The only google result for the error message is this exact post.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP