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
After 20 years owning PCs, I bought my first Mac. I have about 13,000 photos cataloged in Adobe Photoshop Album 2.0, but I'm having trouble figuring out how to preserve my organization in iPhoto (or even if it's possible). Photoshop Album uses an ext [More]
I did an upgrade from 10.5.8 to 10.6 and I am having issues with what seems to be image files. When I save a screenshot from Grab to a .tiff it crashes 90% of the time. Saving in Photshop a JPEG also crashes photoshop cs4. Anyone have any ideas? Ive [More]
I have a macbook pro 15 inch with snow leopard installed.  I was wondering how much it costs to upgrade to loin, if its even possible with my hardware and what the cost is?  Specs on macbook pro are:  Intel Core 2 Duo                                  [More]
Hi experts,    there are notification/latest end/requested start... tabs in step type 'user decision' of workflow.    But these messages are sent to workflow inbox and now i want to sent these messages to outlook.    For notification i could use func [More]
Hi all not of my notifications are working so I want to restore my iPhone 4s back to new then put all my apps, photos, music back on after without restoring from a back up is this possible if so how plzJust restore it as new, instead of from backup i [More]
I have decided not to use the iCloud for syncing because my contacts list has too much private data. I know iCloud is supposedly a secrure site, but I don't trust that much personal info of my friends and family on the Internet. So I am using iTunes [More]
Hi, I need to upgrade my actual SAP DataBase SQL Server 2000 from Service Pack 2 to Service Pack 4 in order to be more secure as a MS consultant is requesting, but following the comments on the SAP note 1026116 attached file, which references this MS [More]
This is a new MacBook with a new CC LR5 installation. There is however no menu choice allowing me to import photos. Np right or left panels at all. When the program opens I get an error message saying there was an error changing modules.I Nearly boug [More]
Hi, I have 400 excel files with the first 5 lines header info - nothing to do with the columns...15 merged columns then the 15 and another 3 columns with data. about half way down the file 12 over the columns turn into 6 columns (2 merged each) Can I [More]
Hi Gurus I have understood the delta mechanisam for LO extraction ( LBWE >>>Job control ) where we first have to select direct delta ( for full load ) and queued delta ( for subsequent delta load ) Am i right? now when we load the data we create [More]