I have approximately 65,000 records (a single string field) that i am creating into a CSV file. I have tested this by having the file dropped to a local folder via File Target. Now I am using the FTP Target to drop the same file on a third party companies SFTP folder. I am receiving a Java error after about 3800 or so records and only those get dropped into the SFTP folder.
Error: com.jscape.inet.sftp.SftpException: com.jscape.inet.sftp.FileService$OperationException: com.jscape.util.l.a.d
The Connector type used by the FTP Target is incompatible with the FTP Server
In the FTP Target advanced properties, select the connector type J2SSH