Hi,
We want to retrieve data from SQl server which has data type as TEXT in SQL server.
The DataType specified in the ODBC stage is LongVarChar with length of
2147483647
When the data lengh is exceed 192203 we are not able to view the data through ODBC satge and when ever we try to open the ODBC stage it is hang for some time and connection was terminated
Even the job also got abort.
Please help me to resolve the issue ?
Let me know any length limitation for LongVarChar
thanks in advance for your help
Regards
Raj
What is the max length of LongVarChar in ODBC
Moderators: chulett, rschirm, roy