November 16, 2011 at 1:03 pm
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
November 16, 2011 at 1:32 pm
What do you mean by 'remote'? Outside of your LAN?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
November 17, 2011 at 12:11 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply