I have automated a script, first step extract data from SQL ( sql server is the source DB) into excel file using “Select to file” activity. Then I have an import which reads from this excel file and loads into Oracle DB using “Import Data wizard” ( oracle is destination DB).
export to Excel works fine but when I start import it gives error/warning “Root element is missing” and import doesn’t work.
when I just runt the data import .tim file it works fine but I noticed one error in the log.
10:54:24 AM Thread (34) Warning: File Call List from M2.xlsx’s encoding ‘System.Text.SBCSCodePageEncoding’ does not match the first file encoding ‘System.Text.UTF8Encoding’. Import may fail.