Create/Upload a file on a Remote Machine
I recently needed to upload a file from my computer to a remote computer. I really didn't know how to do this in C#, so I quickly just made a web application in ASP.NET 2.0 because it was easier (well, maybe because I just knew how to do it). Is there anyway someone can give me a link with some resources about this issue? I can't seem to find any. Or if not links, can someone give me some direction as to what I should be searching for to do what I want to do?
I don't need a client/server application. I just want a client application to select a file and copy the selected file on a remote server somewhere (that is hard coded). So it is generally an uploading of a file. The reason I need to do this is because I want to do a Bulk Insert into SQL, and this SQL Server is located on a remote machine. Well, the only way to do a Bulk Insert is to have SQL see the file, which means it has to be local to the SQL Server.
Do I need to utilize sockets for this?
Is there a better way to insert many rows into SQL from a remote location?