Error Opening Datafile The Handle Is Invalid
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked by: DTS problem -- "Error opening datafile: the handle is invalid" 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 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 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
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 SQL Server Development (2000) DTS prob, Error opening datafile - handle invalid Reply to Topic Printer Friendly Author Topic berengar Starting Member Spain 21 Posts Posted-09/19/2008: 05:54:06 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 HiI have a DTS that I had on another SQL 2000 server and on this new SQL 2000 server when i try to set the transformationsi 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 http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=110970 are correct and I have access to flat file location from this server -- it's the SAME server ...(a shared folder) Edited by - berengar on 09/19/2008 05:55:14 berengar Starting Member Spain 21 Posts Posted-09/19/2008: 11:24:38 I have solved it .. strange i can't refer to the flat file destinations as \\172.x.x.x\folder ..etc I need to refer to it as C:\folder .. etc .. which is strange as on the original it was refeered to by IP ... 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 Issues Database Design and Application Architecture SQL Server 2012 Forums Transact-SQL (2012) SQL Server Administration (2012) SSIS and Import/Export (2012) Analysis Server and Reporting Services (2012) Replication (2012) Availability Groups and DR (2012) Other SQL Server 2012 Topics SQL Server 2008 Forums Transact-SQL (2008) SQL Server Administration (2008) SSIS and Import/Export (2008) High Availability (2008) Replication (2008) Analysis Server and Reporting Services (2008) Other SQL Server 2008 Topics SQL Server 2005 Forums Transact-SQL (2005) SQL Server Administration (2005) .NET Inside SQL Server (2005) SSIS and Import/Export (2005) Service Broker (2005) Replication (20
Things Small and Medium Business Service Providers All Solutions Services Advise, Transform and Manage Financing and https://community.hpe.com/t5/Data-Protector-Practitioners/error-when-restoring-The-handle-is-invalid/td-p/3136294 Flexible Capacity IT Support Services Education and Training Services All Services Products Integrated Systems Composable Systems Converged Systems Hyper Converged Systems Blade Systems Infrastructure Management Software Application Lifecycle Management Application Delivery Management Big Data Analytics DevOps Enterprise Security Hybrid and Private error opening Cloud Information Governance Information Management IT Service Management Operations Management Server Management Software as a Service (SaaS) Software-Defined Data Center Storage Management All Software Servers Rack Servers Tower Servers Blade Servers Density Optimized Mission Critical Servers Servers for Cloud Server Management All Servers error opening datafile Storage All-flash and Hybrid Storage Midrange and Enterprise Storage Entry Storage Systems Data Availability, Protection and Retention Software Defined Storage Management and Orchestration Storage Networking All Storage Networking Switches Routers Access Points and Controllers Wireless LAN Campus and Branch Networking Data Center Networking Wide Area Network Software Defined Networking Network Functions Virtualization Network Management All Networking About UsSupportClearType to search2086159Solutions Transform to a Hybrid Infrastructure Protect Your Digital Enterprise Empower the Data-Driven Organization Enable Workplace Productivity Cloud Security Big Data Mobility Infrastructure Internet of Things Small and Medium Business Service Providers All Solutions Services Advise, Transform and Manage Financing and Flexible Capacity IT Support Services Education and Training Services All Services Products Integrated Systems Composable Systems Converged Systems Hyper Converged Systems Blade Systems Infrastructure Management So