Sitemap

Amicuk Programming Answers

Bulk insert security

2015-10-11   Views:0

Advertisement

I have an SSIS package on server A which calls a stored procedure on server B.  The stored procedure runs the bulk insert command to load an XML file.  The service account which SQL Server Services is running under on server A is a sysadmin on Server

I have an SSIS package on server A which calls a stored procedure on server B.  The stored procedure runs the bulk insert command to load an XML file.  The service account which SQL Server Services is running under on server A is a sysadmin on
Server B, and has permissions to the file.  When I run the package I am getting "Cannot bulk load because the file could not be opened.  Operating system error code 5(Access is denied).  
If I create the server B database on server A, so that the SSIS package and the database where I call the bulk insert command from are both on server A, and run the SSIS package it runs successfully.
When everything is on the same server it works, so whatever account it is using has the necessary permissions.  But that account must not have the necessary permissions on server B.  What other accounts would need permissions on server B?
Thanks for the help.

The replay answer
Advertisement
If you are logged in with a Windows account, BULK INSERT impersonates that user, and that user's Windows permissions apply. If you are logged in with an SQL login, the permissions of the service account applies.
Keep in mind that, the login on server B is a new login. There could be a login mapping set up. Also, several levels of impersonation may not work out well.
Erland Sommarskog, SQL Server MVP, [email protected]

Go to See the other 3 answers

Bulk insert security

Category:DefaultRelease time:2015-10-11Views:130

I have an SSIS package on server A which calls a stored procedure on server B.  The stored procedure runs the bulk insert command to load an XML file.  The service account which SQL Server Services is running under on server A is a sysadmin on Server[More]

Error while running bulk insert in SSIS package

Category:DefaultRelease time:2015-10-11Views:130

Hi: I have an error when I am running bulk insert in SSIS package. I have implemented an SSIS package to update master data directly from R/3, R/3 gives the file in a specified format, I take this and insert all the records into a temporary table and[More]

JDBC Bulk Insert to MS Access

Category:DefaultRelease time:-0001-11-30Views:130

I am trying to do bulk insert to MS Access database from text file. One of the solutions recommended by bbritta is as follows import java.sql.*; public class Test3 {   public static void main(String[] arghs) {     try {       Class.forName("sun.jdbc.[More]

How can I debug a Bulk Insert error?

Category:DefaultRelease time:2015-10-11Views:130

I'm loading a bunch of files into SQL server.  All work fine, but one keeps erroring out on me.  All files should be exactly the same in structure, but they have different dates, and other different financial metrics, but the structure and field name[More]

ODBC, bulk inserts and dynamic SQL

Category:DefaultRelease time:2015-10-11Views:130

I am writing an application running on Windows NT 4 and using the oracle ODBC driver (8.01.05.00, that inserts many rows at a time (10000+) into an oracle 8i database. At present, I am using a stored procedure to insert each row into the database. Th[More]

Bulk inserts and dynamic SQL

Category:DefaultRelease time:2015-10-11Views:130

I am writing an application running on Windows NT 4 and using the oracle ODBC driver (8.01.05.00, that inserts many rows at a time (10000+) into an oracle 8i database. At present, I am using a stored procedure to insert each row into the database. Th[More]

How to get current month from filename and bulk insert from text file into table?

Category:DefaultRelease time:2015-10-11Views:130

I set up some dynamic SQL to help my bulk copy data from a text file to a table.  This works fine for files that come in every day; I get the previous day's data, based on the file name that's placed in the folder.  That's why I'm using the '-1'.  Th[More]

SSIS BULK INSERT unsing UNC inside of ForEach Loop Container Failed could not be opened. Operating system error code 5(Access is denied.)

Category:DefaultRelease time:2015-10-11Views:130

Hi, I am trying to figure out how to fix my problem Error: Could not be opened. Operating system error code 5(Access is denied.) Process Description: Target Database Server Reside on different Server in the Network SSIS Package runs from a Remote Ser[More]

[Forum FAQ] How to use multiple field terminators in BULK INSERT or BCP command line

Category:DefaultRelease time:2015-10-11Views:130

Introduction Some people want to know if we can have multiple field terminators in BULK INSERT or BCP commands, and how to implement multiple field terminators in BULK INSERT or BCP commands. Solution For character data fields, optional terminating c[More]

Bulk Insert into a Table from CSV file

Category:DefaultRelease time:2015-10-11Views:130

I have a CSV file with 1000 records and i have to insert those records into a table. I tried for Bulk Insert command and Load data infile command but it throws error. Am using Oracle 10g Express Edition. I want to achieve it thru query command and no[More]

Bulk inserts on Solaris slow as compared to windows

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts, Looking for tips in troubleshooting 'Bulk inserts on Solaris'. I have observed the same bulk inserts are quite fast on Windows as compared to Solaris. Is there known issues on Solaris? This is the statement: I have 'merge...insert...' que[More]

Hot
Hello, We are running our administration server on one host, and we have multiple other hosts configured as administration nodes. We used our company CA to generate a server certificate for our administration server, and that appears to be working fi [More]
I'm working on an engagement ring affiliate site and hoping I can get some advice. From an SEO stand point is there a rel canonical format I can recreate a duplicate version of a buyer guide as a downloadable pdf without causing duplicate content pro [More]
I'm relatively new to Java and I have a simple problem that I need help with. I have a JSP with checkboxes. The checkboxes all have the same name but have different values. They can be independently "checked" or "unchecked" by the user [More]
SELECT ACT1.PROJ, ACT1.ACT, ACT1.VER, ACT1.DS, ACT1.UC, ACT1.ACT_RN, PRED1.PRED, PRED_DS.DS, PRED_DS.UC01 ACT_TYPE , PRED1.RN, SUCC.SUC ,SUCC.SUC_NAME ,SUCC.SUC_TYPE ,SUCC.SUCC_RN FROM (SELECT A.PROJ , A.VER , A.ACT , A.DS , A.UC01 UC , B.RN ACT_RN F [More]
Post Author: dufernandes CA Forum: .NET Hi there, My problem is the following: I'm using MS Visual Studio 2005 with the standard version of Cyrstal Reports. I wish to design a bar chart along with a line chart (that represents the goal of the data be [More]
Hi All, I have the 1152 connected to a Linksys router. My PC is connected to the same Linksys router. My PC is 192.168.1.101. The AP is 192.168.1.102. I can ping it fine. I put 192.168.1.102 in my browser and I get nothing. Says IE cannot display the [More]
Hi, We are planing to put our resource bundle (.properties) files for all supported languages in Oracle UCM for our Webcenter Portal application. But i am not sure how to use it for labels/text on jsff pages. I can use ridc api for reading the file b [More]
Hi experts Here is a scenario where i need some help. We have standard subcontracting scenario and we use ME20 to create deliveries to subcon vendor . We then do a goods issue to issue the product to the subcon vendor. I want to suppress deliveries t [More]
I am trying to batch process 30 or so fireworks PNGs in Fireworks 8. They are all similar. I want to alter their appearence by applying a hue/saturation filter.  I copy the filter command from history and save it with a name.  I select all the files [More]
I did an update last week.  My computer started acting funny afterwards and I'm not sure what to do now.  I can't open any of my faxes now.Hi paulsaundersdds, What type of file are those fax documents? Are they PDF files? What are you using to open t [More]