MS SQL server Reader error - Invalid Descriptor Index - timestamp

More
6 months 5 days ago #22452 by jvang
Hi,
i'm evaluating the product and like it.

I get this error when i read from a MS SQL Server db, both when using a direct and a ODBC connection. I have read the documentation regarding Connections and Reader and searched the forum but can't find any help.

The problem is reading a field with DataType TIMESTAMP. Is there a solution for this?

The erroris : Reader:{Reader} SQLGetDataA Failed: 07009 [Microsoft][ODBC Driver 17 for SQL Server]Invalid Descriptor Index, Field Name: timestamp

A screendump and the error log is attached.

Regards,
Júst
Attachments:

Please Log in or Create an account to join the conversation.

More
6 months 5 days ago - 6 months 5 days ago #22453 by admin
Quite often the issue is related to working with blob/clob fields
Please read the following article
www.etl-tools.com/wiki/knowledgebase/invalid_descriptor_index

If this does not help please provide us with your table creation script

Mike
ETL Architect
Last edit: 6 months 5 days ago by admin.
The following user(s) said Thank You: jvang

Please Log in or Create an account to join the conversation.