|
Hi,
BULK INSERT Accounts FROM '\MYEXCHANGEMACHINE\DBScripts\Accounts.txt’ WITH ( -- FIRSTROW = 2,
) GO Here MYEXCHANGEMACHINE is my exchange server machine and DBScripts is my Shared Folder.
(comments are locked)
|
|
You need to make sure that your SQL Server service account has access to the remote share. If you are running the service as localsystem or network service you will have some issues connecting. Network Service can be granted on the share but localsystem is a non-started. Using a domain account is the best option in this case, check the Share and NTFS permissions on your exchange server to add the account. Hi jason, can you please explain little in detail. currently what I am doing is:
Mar 23 '10 at 02:52 AM
user-993 (yahoo)
Check to make sur ethat the service account is running as a domain account. Make sure that user has access (share and NTFS) to the share you are trying to pull the file from.
Mar 24 '10 at 03:23 AM
Jason Cumberland
(comments are locked)
|

