DSXchange

Hello,

I am seeing strange behavior of ODBC stage while accessing the SQL Server.

When I use the following SQL

Select
A,
B,
C
from <Table>

It is hanging after fetching some 100 -1000 records (Running on a four node config)


When I run the same job with the following SQL it run fine


Select
A,
B,
C
from <Table> limit 10000

Any Ideas...

No. See if your DBA can help, trace the session and see what the 'hang' might be... or at least help determine if it is database related or not.