Error Opening Datafile The System Cannot Find The Path Specified
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » Data Warehousing » Data Transformation Services (DTS) » system cannot find the path specified for a... system cannot find the path specified for a dts scheduled job Rate Topic Display Mode Topic Options Author Message Pete PetersPete Peters Posted Wednesday, June 28, 2006 10:02 AM Grasshopper Group: General Forum Members Last Login: Monday, March 23, 2015 5:50 AM Points: 10, Visits: 5 Error opening datafile: The system cannot find the path specifiedI have a dts package the when scheduled fails with this error: "Error opening datafile: The system cannot find the path specified"the failure occurs only when the dts job is scheduled thru sql enterprise mgrwhen run from enterprise manager in the data transformation area, the dts job runs successfully. the job basically loads a *.csv file into a sql table. the paths for the input file are valid and visible on the sql server. the user is a valid user with admin accessentire error messageExecuted as user: DRITZDOMAIN\Administrator. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error string: Error opening datafile: The system cannot find the path specified. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 Error Detail Records: Error: 3 (3); Provider Error: 3 (3) Error string: Error opening datafile: The system cannot find the path specified. 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.path:L:\
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from http://www.sqlservercentral.com/Forums/Topic290822-19-1.aspx Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Microsoft SQL Server: Data Transformation Services Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesMicrosoft SQL Server: Data Transformation Services Forum DTS Package Fails http://www.tek-tips.com/viewthread.cfm?qid=1249475 When Scheduled thread961-1249475 Forum Search FAQs Links MVPs DTS Package Fails When Scheduled DTS Package Fails When Scheduled cocopud (TechnicalUser) (OP) 30 Jun 06 14:30 I have a simple DTS package that takes data from SQL Server 2000 using a sql select statement and copies it to a .csv file on a mapped drive to another ftp server.I can open the job and it runs fine, but when I try to schedule it, it keeps failing.I am getting the following errors below.It says it can't find the path specified, but it can find it when it is run and not scheduledExecuted as user: WDB03\SYSTEM. DTSRun:Loading...DTSRun:Executing...DTSRun OnStart:Copy Data from Results to H:\cr.csv StepDTSRun OnError:Copy Data from Results to H:\cr.csv Step, Error = -2147467259 (80004005)Error string:Error opening datafile: The system cannot find the path specified.Error source:Microsoft Data Transformation Services Flat File Rowset ProviderHelp file:DTSFFile.hlpHelp context:0Error Detail Records:Error:3 (3); Provider Error:3 (3)Error string:Error opening datafile: The system cannot find the path specified.Error source:Microsoft Data Transformation Services Flat File Rowset ProviderHelp file:DTSFFile.hlpHel
joneswv&r External User Posts: 1 DTS Scheduled Package Fails but runs manually I have a http://www.mombu.com/microsoft/t-dts-scheduled-package-fails-but-runs-manually-243775.html tab deliminted task that imports data into a SQL Table that runs succesfully if executed. But when I shedule this task if fails. The text file is on a server in a remote location. I have mapped a local drive to this path and when I run the scheduled job it gives me the following information. DTSRun: Loading... error opening DTSRun: Executing... DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147217887 (80040E21) Error string: Error opening datafile: The system cannot find the path specified. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 Error Detail Records: Error: 3 (3); Provider Error: 3 (3) Error string: Error opening datafile: The system error opening datafile cannot find the path specified. 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. Any ideas why it runs manually and not through a schedule? TIA lontae joneswv&r sponsored links 2 25th July 02:38 lontae joneswv&r External User Posts: 1 DTS Scheduled Package Fails but runs manually I tried an UNC path but it couldnt find the path. I am getting the same error. Any Ideas? DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147217887 (80040E21) Error string: Error opening datafile: The system cannot find the path specified. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 Error Detail Records: Error: 3 (3); Provider Error: 3 (3) Error string: Error opening datafile: The system cannot find the path specified. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 DTS