I used to generate a csv file by SQL Server 2005 procedure. This procedure includes a SecureFX commands that creates the CSV file.
After that, I used a .bat file to send the file through SFTP to the target system. The below command is the one that I used to move the file: sfxcl /move
This was working fine with me in SQL Server 2003. However, the problem occurs when I upgraded to SQL Server 2008 R2.
The file is being created and sent successfully, but the target system cannot process it. The below error is being displayed: Parse error in field in input file. Malformed input detected at character 0 using encoding 'UTF-8'
How to fix this problem?
I do appreciate your assistance!
Aucun commentaire:
Enregistrer un commentaire