Does that happen using 32 or 64 bit drivers?:
We are using 64 bit drivers.
Does that happen as well if you do the same SQL SELECT statement from SQL Management Studio?
Current I am unable to execute script on my production server. I will execute and get back you with result..
Has the SQL Server any limitation in the amount of data by chunks it can send at the same time?
As I discussed with our network team, there is no limitation on SQL Server side.
Could you guess anything on this issue?