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
I am working in a school.  Last year we had one ipad cart which holds 30 ipads and one macbook for syncing.  This year we bought another cart of 30 ipads, but not an extra macbook.   Can I sync all 60 ipads to the one macbook computer? In theory ever [More]
I change my Pc and don't found my Original DVD from my Acrobat 9 STANDARD. I have the Key and found in Internet the Pro Version, but not the Standard Version. Where can i download the Standard Version?Downloadable installation files available: Suites [More]
Trying to install Photoshop Elements v.12 silent and i keep getting Exit Error 1. Has anyone experieced this and fixed this error? The software installs fine manually and I did save the log files if anyone is interested in taking a peek.Hi GreenLynx, [More]
There really aren't any details. The process just doesn't work & research suggests that it may well be browser related.Make sure that you drag a valid link or favicon and not selected text on the desktop to create that shortcut. * SaveLink: https://a [More]
Dear All , I  installed unrestricted version  on MSC server by mistake and I tried to install a restricted version after it but I failed do it and after check Cisco doc. I read  that  it is not possible to revert back to restricted version once upgra [More]
So I installed Mavericks on my early MBP2011 all went fine and everything seems to work except the dock with plugged into an external monitor, I have my dock on auto hide and so far it seems that when using an external monitor the dock doesnt react t [More]
I am already a Cloud member...but I keep getting a constant message everytime I open Photoshop or Illustrator or Dreamweaver, to register.  I have been a member for more then 4 months!!!  Enough already!!!Hi MollyMidnight, This is usually due to some [More]
I add a new contact and save it. Next day this contact dosent exists... Iphone 4sDo you sync your contacts with itunes, exchange, gmail or icloud?  If yes does the contact show up in your online contact list then gets deleted later?  If not you may c [More]
AMIS just released the ALS (AMIS Library System) application based on BC4J and JSP with JSTL for JDeveloper 10g and JHeadstart 9.0.5.x. The ALS application is shipped with JHeadstart 9.0.5.x, to demonstrate the use of Toplink with JHeadstart. The app [More]
I need to record two camera interview shoots and turn the video around quickly. What is the best solution using a MacBook Pro and final cut pro?Try reimporting all your media: file>>import>>reimport>>continueRead other 2 answers [More]