I download the 'SftpScriptTaskDemo.dtsx', also download 'psftp.exe' and placed it in 'C:\psftp\psftp.exe', and imported into my SSIS project. I modified the SFTP's credentials...It run fine, no error but i didn't see any file upload to sftp site. what did i do wrong? Please help.

Thank you so much.

I know it's nothing wrong with the credentials because i can manual transfer the files to that server.

1st script i modifed below, and i haven't touch anything on 2nd script.

Public Sub Main()

'Load global variables with values

Dts.Variables("PathToBatch_bat").Value = "c:\psftp\psftp.bat"

Dts.Variables("PathToPsftp_exe").Value = "c:\psftp\psftp.exe"

Dts.Variables("PathToScript_sc").Value = "c:\psftp\script.sc"

Dts.Variables("ServerName").Value = "sftp.server_name.domain"

Dts.Variables("ServerUserName").Value = "username"

Dts.Variables("ServerPassword").Value = "password"

Dts.Variables("ServerSubdirectory").Value = "/sftp"

Dts.Variables("SourceSubdirectory").Value = "C:\psftp\Test.csv"

Dts.TaskResult = ScriptResults.Success

End Sub

End Class

Please help, i'm very appreciated.

Thanks again.