Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hearnie
Starting Member
49 Posts |
 Posted - 2005-04-06 : 09:09:55
|
| Hi There,Im having a problem when I try to run a DTS package which uses Bulk Inserts with the Source File on a share on another server.The SQL Server machine has access to it and can open/read/write to the share. When the package runs and the datasource is of the type '\\someserver\somefolder\somefile' it fails on the Bulk Insert saying there is an operating system error and that Access is Denied.From within the same DTS package I can execute a ActiveX Script that can access the same file and read from it ok.anyone have any idea's as to what is happening here.H. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-04-06 : 19:23:07
|
| The SQL Server service is running under an account that does not have access to that network share. For instance, if it is running under the LocalSystem account, it will have no network access at all. You'll need to change the service account to a domain account with the correct permissions, or have your DBA or network admin do it. |
 |
|
|
hearnie
Starting Member
49 Posts |
Posted - 2005-04-08 : 05:39:07
|
| The folder is not blocked to anyone, everyone has access to it so should the SQL Service account still not be able to get at it?I'll try your suggestions anyhowH. |
|
|
|
|
|
|
Bulk Insert Problems When DataSource is a share