Problem with ODBC stage
Posted: Thu Aug 02, 2007 1:49 am
Hi,
I am using ODBC stage to read the data from SQL Server to put into a sequential file. I am just using select * from <tablename> as the query in the ODBC stage. But strange, Data from the character column type and date column type are getting truncated. For other data type its fine.
Any light on this issue? And also any solution for this.
Thanks in advance,
Birendra
I am using ODBC stage to read the data from SQL Server to put into a sequential file. I am just using select * from <tablename> as the query in the ODBC stage. But strange, Data from the character column type and date column type are getting truncated. For other data type its fine.
Any light on this issue? And also any solution for this.
Thanks in advance,
Birendra