From: jarman_andrew@hotmail.com   
      
   "Erland Sommarskog"  wrote in message   
   news:Xns9D3A26113A8Yazorman@127.0.0.1...   
   > DennBen (dbenedett@hotmail.com) writes:   
   >> I am having trouble executing command line to transfer files via an   
   >> SFTP server from a call in T-SQL (version 2005) where putty is the   
   >> client application. The solution has to be able to work on SQLExpress   
   >> and needs to be backwards compatible to SQL 2000, so I'm not sure if   
   >> SSIS is even a viable option for me.   
   >>   
   >> The command executes perfectly in dos prompt, but in MSSQL it just   
   >> hangs on the connection command and never makes the connection.   
   >   
   > I would guess that it's waiting for user input. I hope this is a   
   > command-line utility? If it's try to open a window of any sort, it's   
   > not going to work out well at all.   
   >   
   >   
   >   
   >   
   > --   
   > Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
   >   
   > Links for SQL Server Books Online:   
   > SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   > SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   > SQL 2000:   
   > http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
   >   
      
   As Erland mentioned, this will invoke psftp in 'interactive' mode, I believe   
   you need the 'batch' functionality (-b). See   
   http://the.earth.li/~sgtatham/putty/0.52/htmldoc/Chapter6.html#6.1.5 for   
   usage.   
      
      
   Andy   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)