Hi Gani
You should provide more information about your connection, how it is configured, where you are executing the package during development, whether Excel is installed on that server, etc.
And maybe it is not the best idea to use such old VS ;-)
I hope my answer is helpful to you,
Your
Bjoern Peters
If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!