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.
You have to use a location that the SQL and the user that it is running as has access to. This means that only location local to SQL will be available if you are using a drive path like c:\ or E:\ otherwise
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.