Dtsrun Error String 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
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Why am I receiving Error opening datafile: Access is denied.? SQL Server > SQL Server Integration Services Question 0 Sign in to vote I have a SQL 2000 server installed on a box, and the SQL agent is running as Domain\User1. On this SQL server I have a DTS package that reads text files and inserts the http://www.sqlservercentral.com/Forums/Topic18833-5-1.aspx information into a database table. I have a text file on another server. The text file is in a shared directory and everyone has permissions for full control of the shared directory, including Domain\User1. I have a program that calls the DTS package. Every time I call the DTS package I get the following errors: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/57a942c4-f6f9-4d5e-839f-d7da02e46cf3/why-am-i-receiving-error-opening-datafile-access-is-denied?forum=sqlintegrationservices The execution of the following DTS Package failed: Error Source: Microsoft Data Transformation Services Flat File Rowset Provider Error Description:Error opening datafile: Access is denied. Error code: 80004005 \Error Help File:DTSFFile.hlp Error Help Context ID:0 Package Name: ADC_TD_Financial_Load Package Description: (null) Package ID: {63185E33-C3AE-40BF-BB34-AE212F00F5BA} Package Version: {339E9333-29F8-44E6-AEB9-7A84C72800A9} Package Execution Lineage: {CD62E2E8-8996-46CC-8F50-E433C74C4FBC} Executed On: CTOR-DC01SQL01 Executed By: MS_ARIELDC_DEV Execution Started: 7/21/2010 4:50:33 PM Execution Completed: 7/21/2010 4:50:33 PM Total Execution Time: 0.016 seconds Package Steps execution information: Step 'DTSStep_DTSDataPumpTask_1' failed Step Error Source: Microsoft Data Transformation Services Flat File Rowset Provider Step Error Description:Error opening datafile: Access is denied. Step Error code: 80004005 Step Error Help File:DTSFFile.hlp Step Error Help Context ID:0 Step Execution Started: 7/21/2010 4:50:33 PM Step Execution Completed: 7/21/2010 4:50:33 PM Total Step Execution Time: 0.016 seconds Progress count in Step: 0 Step 'DTSStep_DTSDynamicPropertiesTask_1' succeeded Step Execution Started: 7/21/2010 4:50:33 PM Step Execution Completed: 7/21/2010 4:50:33 PM Total Step Execution Time: 0 seconds Progress count in Step: 0 ********************************************************************
is your first visit, be sure to check out the FAQ by clicking the link above. You may have to http://www.dbforums.com/showthread.php?441699-Error-opening-datafile-Access-is-denied register before you can post: click the register link above to http://www.sql-server-performance.com/forum/threads/dts-failed-to-run-when-scheduled-in-job.25602/ 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 dtsrun error Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 07-25-02,19:51 #1 uday View Profile 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 dtsrun error string 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 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
DTS failed to run when scheduled in JOB Discussion in 'SQL Server DTS-Related Questions' started by hohohann, Feb 22, 2008. hohohann New Member Hi, I have a DTS package to export data into a text file. It works fine when i execute the DTS package itself, and there is a text file generated. However, when i scheduled it to run in Job, the job failed to execute the DTS by returning this error message: DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) 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: DTSStep_DTSDataPumpTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed. What's going on with it? hohohann, Feb 22, 2008 #2 martins New Member It looks like a security issue. Check the account which SQLAgent runs under. You will probably find that this particular user does not have access to the folder it needs to save the file to. martins, Feb 22, 2008 #3 (You must log in or sign up to reply here.) Share This Page Tweet Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums. Your name or email address: Do you already have an account? Forgot your password? No, create an account now. Yes, my password is: Stay logged in SQL Server Performance Forums Home Forums > ARCHIVED SQL Server Posts > SQL Server 7.0 and 2000 Forum Topics > SQL Server DTS-Related Questions > Forums Forums Quick Links Search Forums What's New? Members Members Quick Links Registered Members Current Visitors Recent Activity Help Help Quick Links Smilies BB Codes Trophies Search titles only Posted by Member: Separate names with a comma. Newer Than: Advanced search...