We have a requirement where we need to migrate FTP FCC to SFTP FCC.Below are the difficulties are identified during conversion of FTP to SFTP.
1.Missing RecordSet Sequence Option in SFTP FCC :-To achieve my requirement ,i have used SFTP MTB option with StructPlainTo XML conversion to achieve this recordset sequence option.Please let me know if this option is available with latest SFTP service pack.
2. xml.ignoreRecordsetName =true :-In SFTP MTB this parameter is not working and inserted recordset name in the input file which is not fit with source data type.By using this option in FTP FCC it removes the recordset name while converting text file to xml.
Please provide your inputs and suggestion to remove the recordsetname at transformation step to fit with the source schema.
Appreciate your help!!