Dynamic Schema load handling more than 8000 chars column
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)
