I am trying to import data into a SQL Server. I can import through the Import and Export Data wizard. I cannot import from my machine using
BULK IMPORT or
OPENROWSET since the file is not on the server machine. How does the IED wizard insert data into its target db? Does it go row by row?
Are there any other possible solutions to importing data from my machine?