I have Used the WInscp.exe to downaload the files from sftp and in order do that created a SSIS package and called the script file from the ssis package, Here the problem is with the file names and when ever I mentions complete file name then The file was downloading to the working directory but if I specifies *.* or *.csv then nothing was downloading from the file and on top of the getting error message......
open batch on
open confirm off
Open SFTP connection
Option transfer binary
get *.csv path
error message:: No valid incoming packet found; Error listing 'directory'
Please correct me if i am doing some thing wrong.......