Error Creating Datafile Mapping Dts
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 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 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 objec
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2000 Forums Import/Export (DTS) and Replication (2000) Successfully quiting a job with empty input file. Reply to Topic Printer Friendly Author Topic ditch Flowing Fount of Yak Knowledge South Africa 1466 Posts Posted-02/03/2004: 03:44:40 http://forums.databasejournal.com/showthread.php?25809-SQL-2000-DTS-Help-Needed I have a SQL Job which executes a few DTS Packages.The first package checks for file existence using Custom Tasks (dll's developed in VB6).The second Loads the file into a Table using a Transform Data Task.Packages 3 to 5 use Transact sql tasks to fetch related data etc and store in a staging environment and then eventually transfer the data to a production environment.My problem is in Package no 2.When the input http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=32228 file is empty then the transform data task returns the following error: 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 validI was thinking that the solution for this problem would be to Break the Job up into 2 different jobs: The first one would execute package 1 as well as a new package containing an activex task which would check the file size and if the file is not empty execute the second job which contains the remainder of the packages eitherwise it should quit reporting success.If this is possible then I would like to know the syntax in activex to execute a SQL Job (I can't seem to find this anywhere)? If this is not possible then does anybody else know a better solution? raymondpeacock Constraint Violating Yak Guru United Kingdom 367 Posts Posted-02/03/2004: 06:04:58 Create an ActiveX script on the Workflow properties to set DTSTaskExecResult_Success or DTSTaskExecResult_Failure based on the existence and size properties using Scripting.FileSystemObject.Raymond Topic Reply to Topic Printer Friendly Jump To: Select Forum General SQL Server Forums New to SQL Server Programming New to SQL Server Administration Script Library Data Corruption I
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) 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" https://www.experts-exchange.com/questions/23918539/error-importing-a-files-in-mssql-2000.html 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
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > error importing a files in mssql 2000 Want to Advertise Here? Solved error importing a files in mssql 2000 Posted on 2008-11-19 MS SQL Server Query Syntax VB Script 1 Verified Solution 10 Comments 330 Views Last Modified: 2013-11-30 hi, i have this problem: i am generating every 2 hours 4 comma delimited file with filename as1, as2, as3, as4 in order to import them using a dts in my mssql 2000 db sequentialy. the files can be of 0kb or have data in it. in my dts i am importing all 4 files in the db. now i get an execute error for the files that are of 0kb. the files with data are imported which is ok. but how can i make the dts to do not execute the importing of files that are of 0kb and do only the import of files that are > than 0kb. 0 Question by:eaweb Facebook Twitter LinkedIn Google LVL 75 Active 2 days ago Best Solution byAnthony Perkins >> I edited the package with disconnected edit and run the package<< Why are you editing it? I said "see the names of each Task and Step". I suspect your package is totally hosed now, I suggest you Go to Solution 9 Comments Message Author Comment by:eaweb2008-11-19 i get the following step error: error creating datafile mapping: the volume for a file has been externally altered so that the opened file is no longer valid 0 LVL 15 Overall: Level 15 MS SQL Server 14 Query Syntax 7 VB Script 1 Message Active 7 days ago Expert Comment by:dbbishop2008-11-19 You have this posted in the VB Script zone, so if you have the code in an ActiveX script task, you can use the filesystem object to determine the size: Dim fso Set fso = CreateObject("Scripting.FileSystemObject") fso.GetFile("path & filename") If fso.Size > 0 Then ' import the file End If 0 LVL 75 Overall: Level 75 MS SQL Server 62 Query Syntax 18 VB Script 6 Message Active 2 days ago Expert Comment by:Anthony Perkins2008-11-19 Is there any task that needs to execute after that. In other words do you do anything regardless of whether the file is 0