Dynamic Schema load handling more than 8000 chars column

Anonymous — Tue, 23 Aug 2016 10:00:59 GMT

I am trying to sync a Salesforce object into the MS SQL Server using dynamic schema. So i setup only one column mapping with data type as dynamic and executing the job.
tSalesForceInput--> tMSSQLOutput
But I am getting error on columns where length is defined as 32000 in sharepoint( but actual data coming in is less than 8000 chars). In SQL 2005 and above , we can store large texts using varchar(max) data type.. but according to errors it seems the maximum value you can transform is 8000 chars using dynamic schema. Also it should not throw error when actual value is less than 8000 chars.
Any workaround? I dont want to map all columns to sync objects from sharepoint, it has to be dynamic.
-MARC
Error detail:
Exception in component tMSSqlOutput_1
java.sql.SQLException: The size (32000) given to the column 'Description' exceeds the maximum allowed for any data type (8000).
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:809)
at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1282)
at salesforce.vdatainstitutional_salesforce_test_sync_0_1.vDataInstitutional_Salesforce_Test_Sync.tSalesforceInput_1Process(vDataInstitutional_Salesforce_Test_Sync.java:5403)

Re: Dynamic Schema load handling more than 8000 chars column

Anonymous — Wed, 24 Aug 2016 08:42:28 GMT

Hi,
In MS SQL the maximum varchar length is 8000. If you need larger field content, you need to change that column to TEXT.
Best regards
Sabrina

Re: Dynamic Schema load handling more than 8000 chars column

Anonymous — Wed, 24 Aug 2016 12:40:53 GMT

Thanks xdshi, but i am using dynamic schema, where the table is dropped and recreated by talend. How do I do it using dynamic schema?
tMSSqlOutput_1

topic Re: Dynamic Schema load handling more than 8000 chars column in Talend Studio

Dynamic Schema load handling more than 8000 chars column

Re: Dynamic Schema load handling more than 8000 chars column

Re: Dynamic Schema load handling more than 8000 chars column