var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Bulk Importing from a Remote Data File
I wish to import a data file that I have on a remote server into a sql server table
Am using the UNC path as in the following example:
But I get an error saying unable to open file neworders.txt.
BULK INSERT SalesOrderDetail
How do I pass the login details to where the datafile is stored so that the above query can read the file?
Is the folder having the file fully shared?
Also check that xp_command shell is on? You can check it in sql surface area configuration
You do not need to turn xp_cmdshell on for bulk import.
Originally Posted by jassi.singh
Please check if the folder share \\computer2\salesforce\dailyorders is accessible to the service account or not.
Originally Posted by ozzii
Did your bulk import worked?