Dtsrun Error Opening Datafile Access Is Denied
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 7,2000 » Administration » Job failed with access denied on opening... Job failed with access denied on opening datafile Rate Topic Display Mode Topic Options Author Message tyangtyang Posted Thursday, December 4, 2003 9:40 AM SSC-Enthusiastic Group: General Forum Members Last Login: Friday, June 20, 2014 12:44 PM Points: 137, Visits: 201 Does anyone experience the following, the job running is under my account, I am the local Admin and sysadmin on SQL server.DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: Copy Data from PSDivUnits to [eBilling].[dbo].[PSDivUnits] Step DTSRun OnError: Copy Data from PSDivUnits to [eBilling].[dbo].[PSDivUnits] Step, Error = -2147217887 (80040E21) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 Error Detail Records: Error: 5 (5); Provider Error: 5 (5) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 DTSRun OnFinish: Copy Data from PSDivUnits to [eBilling].[dbo].[PSDivUnits] Step DTSRun: Package execution complete. Process Exit Code 1. The step failed. Post #18833 Rodrigo AcostaRodrigo Acosta Posted Thursday, December 4, 2003 9:48 AM SSCommitted Group: General Forum Members Last Login: Thursday, May 21, 2015 7:40 AM Points: 1,581, Visits: 8 Check that the account that runs the SQL agent service has access to that file. Post #89845 tyangtyang Posted Thursday, December 4, 2003 1:36 PM SSC-Enthusiastic Group: General Forum Members Last Login: Friday, June 20, 2014 12:44 PM Points: 137, Visits: 201 Yes, everyone has full control on this file. Post #89846 dgoddendgodden Posted Friday, December 5, 2003 2:15 AM Grasshopper Group: General Forum Members Last Login: Thursday, May 29, 2008 7:55 AM Points: 11, Visits: 12 Questions....Does the file sit on the same server as the one you have local admin rights to? Or is it on another server or even in another domain?Is the file accessed by any other processes?What are the permissions given to the proxy account? Post #89847 EdVassieEdVassie Posted Friday, December 5, 2003 4:44 AM Hall of Fame Group: General Forum Members Last Login: Tuesday, August 30, 2016 2:28 AM Points: 3,034, Visits: 3,711 Are you using a Job Output File (seen in the Advanced tab on thejob step)? We had a problem where the proxy acco
is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 4 of 4 Thread: Error opening datafile: Access is denied. Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 07-25-02,19:51 #1 uday View Profile http://www.sqlservercentral.com/Forums/Topic18833-5-1.aspx View Forum Posts Visit Homepage Registered User Join Date Jul 2002 Location sydney, australia Posts 3 Unanswered: Error opening datafile: Access is denied. Hi all! I am using SQL Server 7.0 Ent Edition. Defined a DTS Local Pkg which basically picks up a whole heap of txt files on a unix m/c and loads them into sql tables. I have a mapped drive http://www.dbforums.com/showthread.php?441699-Error-opening-datafile-Access-is-denied to the unix box and yes MSSQLServer a/c has access to this mapped drive. The task runs fine when I execute it, but when I try to run it at scheduled intervals via NT Scheduler, I get this message. E:\ProgramFiles\MSSQL7\Binn>DTSRun /S SYD1SHIVA /E /N Test Package DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147217887 (80040E21) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 Please help! Regards Uday Attached Files output.txt (1.2 KB, 112 views) Reply With Quote 07-26-02,09:04 #2 achorozy View Profile View Forum Posts Visit Homepage Registered User Join Date Dec 2001 Location Toronto, Canada Posts 335 You say that MSSQLServer a/c has access, I guessing that a/c is the Agent Service for SQL. But you are running the job through NT Scheduler as who? In your batch file enter the "SET" command at the top and make sure the output is directed to a file. This will show you the USERNAME and USERDOMAIN environment variables of who you are runni
help? Post your question and get tips & solutions from a community https://bytes.com/topic/sql-server/answers/80769-problems-dts-package-access-denied of 418,501 IT Pros & Developers. It's quick & easy. Problems with DTS package. Access denied P: n/a Jim Andersen Hi, I made a DTS-package and it works when I execute it manually, but when it is run by the SQL Server Agent, it fails. I have use the guide to create dtsrun error a maintenance plan. That doesn't work so good either. It runs Optimizations, but not integrity checks or backups (probably because integrity checks failed). The following from the log file: Executed as user: HT-DOMAIN\INTRAB-SQL. ...: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_3 DTSRun OnError: dtsrun error opening DTSStep_DTSDataPumpTask_1, Error = -2147024891 (80070005) Error string: Access is denied. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error Detail Records: Error: -2147024891 (80070005); Provider Error: 0 (0) Error string: Access is denied. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error: -2147024891 (80070005); Provider Error: 0 (0) Error string: Cannot open a log file of specified name. Access is denied. Error source: Micr... Process Exit Code 1. The step failed. Log-file endeth here..... My "data-sources"/Connections is set up to use sql-server authentication where I enter superuser name+password, not windows authentication. If I browse around using SQL-EM: Under Security - Logins HT-DOMAIN\intrab-sql: Tab General: Grant Access Tab Server Roles: System Administrators Tab Database Access: checkmark at Mbestil, user=dbo; database roles for mbestil = public + db_owner I also have som problems identifying where the package fails. I have given the individual "steps"/"transformations" so