DTS Text file Creation and moving to another server i.e SFTP account

• ajashadi

  Ten Centuries

  Points: 1017

  More actions

  June 19, 2006 at 8:24 am

  #68714

  Hi,

  I have a DTS package working fine. The idea is to create a text file on database server i.e local machine on which DTS would run and then SOMEHOW move this text file to another server to an SFTP folder. The client will access/view this file by using there SFTP account.. How can I do this. I tried xp_cmdshell i.e

  Declare @SQLCMD varchar(500)

  Set @SQLCMD = 'move \\.3\c$\ClientExports\Export.txt, \\.10\d$\Test'

  Exec master.dbo.xp_cmdshell @SQLCMD

  but it didnt work.

  Any suggestions are welcome.. Also I was thinking after the text file creation, having a script or something to move it to destination I want...

• sree-226516

  SSCrazy

  Points: 2590

  More actions

  June 19, 2006 at 8:55 am

  #644631

  I think there shouln't be any comma between source and destination path.It should be something like this.

  Set @SQLCMD = 'move \\.3\c$\ClientExports\Export.txt \\.10\d$\Test'

  Thanks,

  SR

   

  Thanks,
  SR