I've dropped the putty solution in favor of ssissftp.codeplex.com, a custom package that has worked very well for me.

for the wildcard you need to use mget instead of get (as per putty docs)

if you want to copy to another folder, you need to add a line :

lcd H:\LCL\FOLDER\NAME

get PG335_20110803_29144.xml

quit

that's "LCD"

Dear Stan, if your file is on the sFTP root server, you don't need to change directory. The SourceFilePath is only for PUT activity. GET will download into the directory...

Correction : I mixed up markmeiller's response with the winscp one. markmeiller's ftprequest is a no-go because it doesn't support sftp which is core to the article.

I will stick to...

At my job, I develop DTS packages on a dev server, they then need to be copied to our clients test environment. The client will, after succesful testing, do a...