FROM SQL SERVER 2005 DOWNLOAD FILES FROM PSFTP

[ps_prakash02]

Hi, My Requirement: My Client will place inputs files in psftp. we need to write a procedure in sql server 2005, which has to periodically check the psftp for files if any files found in psftp then the sql procedure has to download those files to local folder. Actually i have written a batch file which login to psftp and download the files to local folder. if i run the batch file manually the batch file download files from PSFTP to local folder, but if i execute the same batch file in management studio its showing as executing but its not doing anything and after some seconds management studio is not responding. if anybody can tell me how to do this it will be great help for me. the command i used is exec master..xp_cmdshell '\\server1\file\download.bat' Thanks & Regards, P.Prakash

[Jan Wild]

I have the same problem. Did you found a solution?