Error Creating Datafile Mapping
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 2 of 2 Thread: dtsrun: datafile mapping error 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 01-30-04,03:45 #1 erictan View Profile View Forum Posts Registered User Join Date Jan 2004 Posts 1 Unanswered: dtsrun: datafile mapping error Hi need lots of help here. I have a dts package scheduled to run hourly as job since recent November. (Win2000 server, MSSQL2000 standard) Its been running fine, except last few days, SQL Agent shows it attempted to run it but fails Checking the history for the job i got this error message each time: ================================================== ====== DTSRun: Executing... DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnError: DTSStep_DTSDataPumpTask_2, Error = -2147467259 (80004005) Error string: Error creating datafile mapping: The volume for a file has been externally altered so that the opened file is no longer valid. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 Error Detail Records: Error: 1006 (3EE); Provider Error: 1006 (3EE) Error string: Error creating datafile mapping: The volume for a file has been externally altered so that the opened file is no longer valid. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 DTSRun OnFinish: DTSStep_DTSDataPumpTask_2 DTSRun: Package execution complete. Process Exit Code 1. The step failed. ================================================= The key information i think would be these few lines: Error creating datafile mapping: The volume for a file has been externally altered so that the opened file is no longer valid. I don't think its SQL Agent as its scheduling is running other jobs fine(backup) The DTS package runs fine manually. Such i suspect dtsrun.exe itself. But where do i go from here? Thks. Reply With Quote 11
New? Advanced Search Forum Database Discussions MS SQL Server 7/MS SQL Server 2000 SQL 2000 DTS Help Needed If this 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 5 of 5 Thread: SQL 2000 DTS Help Needed Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch http://www.dbforums.com/showthread.php?980727-dtsrun-datafile-mapping-error to Threaded Mode 09-12-2002,09:39 AM #1 sql200_help View Profile View Forum Posts Registered User Join Date Sep 2002 Posts 2 SQL 2000 DTS Help Needed I have created several DTS packages that are exectued by a COM application on receiving the text source files from the data source. The problem I am having is that if the source file is empty I receive the error "Error creating datafile mapping: The http://forums.databasejournal.com/showthread.php?25809-SQL-2000-DTS-Help-Needed volume for a file has been externally altered so that the opened file is no longer valid". If the package fails then the calling application returns an error too. I am wondering if it is possible to have a dts package succeed if it receives an empty file, or if I can create an activeX step at the beginning of the package to check the size. Thanks, Steve Reply With Quote 09-12-2002,10:04 AM #2 rmiao View Profile View Forum Posts Moderator Join Date Sep 2002 Posts 5,938 Maybe can try it with xp_getfiledetails. Reply With Quote 09-12-2002,10:30 AM #3 sql200_help View Profile View Forum Posts Registered User Join Date Sep 2002 Posts 2 Is it possible in the DTS Designer to make a subsequent task execute dependent on query results? Reply With Quote 09-12-2002,11:38 AM #4 rmiao View Profile View Forum Posts Moderator Join Date Sep 2002 Posts 5,938 Yes with workflow, or add as job step if you run it as task. Reply With Quote 09-12-2002,11:19 PM #5 Stephen View Profile View Forum Posts Registered User Join Date Sep 2002 Posts 169 One option is to use an activex task to check whether the file exists using the file system object. You could also use the dy
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked by: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/39f31c47-bce9-4db3-b028-e0e51e1691d2/dts-problem-error-opening-datafile-the-handle-is-invalid?forum=sqlintegrationservices DTS problem -- "Error opening datafile: the handle is invalid" http://www.verycomputer.com/156_a5e57b372a29e2ba_1.htm SQL Server > SQL Server Integration Services Question 0 Sign in to vote Hi I have a DTS that I had on another SQL 2000 server and on this new SQL 2000 server when i try to set the transformations error creating i get the following error "Microsoft Data Transformation Services flat file rowset provider Error Description: Error opening datafile: the handle is invalid"I even tried creating the DTS from scratch and re creating the flat file connection, but i still get this message, All paths are correct and I have access to error creating datafile flat file location from this server -- it's the SAME server ...(a shared folder) Friday, September 19, 2008 9:52 AM Reply | Quote All replies 0 Sign in to vote OK , I seem to have solved it , by refering to flat file connections as "C:\folder ...." etc .. rather then by \\172... etc ... the problem dissapeared .. maybe it was a drive mapping issue ?? not sure .. but if anyone gets a similar error .. try referencing location by drive rather then IP/ PC name... Monday, September 22, 2008 11:26 AM Reply | Quote Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate? Privacy statement © 2016 Microsoft. All rights reserved.Terms of Use|Trademarks|Privacy Statement|Site Feedback
a txt file and populates it into the database. Now, if the txt file is empty, the I get an error: ____________________________________________________________________________ ____________________________________ Step Error Source: Microsoft Data Transformation Services Flat File Rowset Provider Step Error Description:Error creating datafile mapping: The volume for a file has been externally altered so that the opened file is no longer valid. ____________________________________________________________________________ _____________________________________ What I need is, if the file does not contain any records, it should not proceed but abort the execution of the package, IT SHOULD NOT GIVE AN ERROR. Thanks in anticipation of help provided. Regards ~brij Top empty source file gives error when DTS executes by Johnn » Sat, 05 Oct 2002 23:33:14 Use an ActiveXscript task with FileSystemObject to find the file, open and check if empty. Johnny Quote:> Hi All, > I have a DTS package and it reads data from a txt file and populates it into > the database. > Now, if the txt file is empty, the I get an error: ____________________________________________________________________________ Quote:> ____________________________________ > Step Error Source: Microsoft Data Transformation Services Flat File Rowset > Provider > Step Error Description:Error creating datafile mapping: The volume for a > file has been externally altered so that the opened file is no longer valid. ____________________________________________________________________________ Quote:> _____________________________________ > What I need is, if the file does not contain any records, it should not > proceed but abort the execution of the package, IT SHOULD NOT GIVE AN ERROR. > Thanks in anticipation of help provided. > Re