Forums

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.

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