I have a user who wants to bcp or bulk insert files from his local drive or from the share drive.
My expectation is that BCP can be done from his local command line, but we're having issue getting the syntax correct.
bcp inventory.dbo.fruits in "C:\fruit\inventory.txt" –Sservername -c -T
The other option we've considered is a bulk insert so he could call it from his SQL. Is there a way to refer to the Users C drive from within the SQL? We get error code 53 when we try to run it against the share drive.
What is the best approach?