I've created SSIS package to create a data file and sending file to SFTP. SQL script > save data into .csv > send file to SFTP. However files get generated but file isn't able to transfer to SFTP site.
File gets transferred when I test manually but not in automated and getting failed with following error. I have password set on package property still getting failed.
Code: 0xC001405F Source: Package Description: Failed to decrypt an encrypted XML node because the password was not specified or not correct. Package load will attempt to continue without the encrypted information. End Error Error: 2022-04-22 11:11:33.07 Code: 0x00000000 Source: TF Secure FTP Task ExecuteTask Failed Description: ChilkatLog: UploadFileByName: DllDate: Jul 26 2021 ChilkatVersion: 22.214.171.124 UnlockPrefix: SNTRYN.CBX072023 Architecture: Little Endian; 64-bit Language: .NET 4.0 / x64 VerboseLogging: 0 SshVersion: SSH-2.0-Serv-U_126.96.36.1997 SftpVersion: 0 Component successfully unlocked using purchased unlock code. Must first have an open SFTP channel (by calling InitializeSftp). --UploadFileByName --ChilkatLog End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:10:23 AM Finished: 11:11:33 AM Elapsed: 69.718 seconds. The package execution failed. The step failed.