Copy File to Remote Machine..... Help

• quillis131

  Hall of Fame

  Points: 3706

  More actions

  November 16, 2011 at 1:03 pm

  #250682

  flat file genrated on local machine ... What in case I want to Copy, flat file generated to REMOTE MACHINE .... Can we do this Using SSIS File System Task.

  If not Plz guide me C# script ...Thank you guys

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  November 16, 2011 at 1:32 pm

  #1408846

  What do you mean by 'remote'? Outside of your LAN?

  ---

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  November 17, 2011 at 12:11 am

  #1408984

  If the remote machine is outside of your LAN, won't FTP be a better choice?

  If it is not, do you have a UNC path or something like that? If you do, you can use File System Task, but use the Rename method, it works better.

  Regarding C#, take a look at the FileInfo.MoveTo or FileInfo.CopyTo methods.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP