Hi Guys,
Please need your help to resolve this issue.
Job design
ODBC Connector -> Copy -> DataSet.
When I give the below SQL query in ODBC Connector, Iam able to view data.
select ID, Date, status, Description from Headcount
But when I give below SQL query, its having issue.
select ID, Date, status, Description, Created from Headcount
Its giving me the below error.
An exception occured while trying to receive the response from the handler: An exception was received from the handler; ODBC function
"SQLGetData" reported: SQLSTATE = 07009:Native Error Code = 0: Msg = [IBM(DataDirect OEM)[ODBC SQL Server Driver][ SQL server Driver]
Invalid Descriptor Index
The above SQL works fine in SQL server.
The column Created is datetime in Source and having the below values.
2013-04-18 04:11:03.020
2013-04-18 04:11:42.177
Any thoughts on this.
Thanks,
[odbc sql server driver] Invalid descriptor index
Moderators: chulett, rschirm, roy