Forums

I am trying to query a Greentree table and return a substring on a field using Microsoft's SSIS.

SELECT oid, substring(statusText, 1, 100) FROM GLJournal

Gives me an error saying:
state: '42000'. Native Error Code: 8258. [Jade Software Corporation][JADE ODBC Server] Expecting: 'FROM'; found '(' at 12

Try leaving out the substring function, eg

SELECT oid, statusText FROM GLJournal

Yes removing the substring works, it's just that SSISnow regards the field as a VARCHAR(MAX) and imports the rows line by line. Whereas if I could use substring I think it would avoid the MAX and use a quicker bulk import.