SQL Server Performance Forum – Threads Archive
BULK INSERT in 3 tierHow to bulk insert the data in 3 tier system.
We are having separate Database server and web server.
How can we access files from webserver in BULK INSERT command executing on Database server?
Access the file via a UNC share \MYWEBSERVERMYSHARENAME
or map a drive letter on SQL to point to an area on the webserver (marginally less reliable) Remember to set up permissions on the share/drive mapping (and the underlying drive area) so sql account has permission to access it. Sql will need to run as a domain user for this.
I would suggest with UNC share than mapping a drive on the sQL server,http://docs.deepmetrix.com/xsp/user_guides/lsxsp_ref_UNC.aspx fyi. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.