How to upload file to SQL Server for Bulk Insert?

[ABC]

Our environment has two servers, one is web and another is SQL Server. I
can write upload file to IIS. But, I cannot call SQL Server's BULK Insert
statement.

Is there any idea to handle this case?

 

[Galin iliev]

you canread content with FileUpload class

byte[] fileContent = new byte[FileUpload.PostedFile.ContentLength];

string sFileName =
System.IO.Path.GetFileName(FileUpload.PostedFile.FileName);

FileUpload.PostedFile.InputStream.Read(fileContent, 0,
FileUpload.PostedFile.ContentLength);

and then save it to database with insert query (use image for SQL column
type )

Hope this helps