Error Occurred During Creation Of Dts Package
från GoogleLogga inDolda fältSök efter grupper eller meddelanden
2000 client tools installed won't edit DTS packages within SEM. The error "Error occurred during creation of a DTS package." appears first, and it is followed by "The selected package cannot be opened. The DTS Designer has been closed." The sqlstp.log file includes the following lines: 11:30:35 Begin Action PostSetupRegistry: 11:30:35 C:\PROGRA~1\COMMON~1\MICROS~1\SQLDEB~1 \sqldbreg.exe -RegServer 11:30:35 Process Exit Code: (-2147312566) Error loading type library/DLL. 11:30:35 End Action PostSetupRegistry I attempted to manually unregister, and then re-register the following files, in this order: dtsffile.dll dtspkg.dll dtspump.dll axscphst.dll The unregistration attempt fails for dtspkg.dll, which leads me to believe https://groups.google.com/d/topic/microsoft.public.sqlserver.dts/Nv0tpMzBWhg that it wasn't registered to begin with. The re-registration attempt fails for both dtspkg.dll and dtspump.dll. All manual attempts were made with regsvr32.exe. I have also tried performing an uninstall of the client tools, then a re-install, as well as an update to SQL Server 2000 SP2 on the client, none of which has solved the problem. The error from sqlstp.log mentioned above occurs at each install attempt. The http://www.verycomputer.com/156_1c383559696e8446_1.htm corresponding .rll files appear to be in place, and comcat.dll version 5.0.2195.1 is present in C:\WINNT\system32\. Custtask.dll is registered. The server is SQL Server 2000 SP2 with the post-SP2 hotfix (8.00.608). Other client boxes with the 2000 client tools, both SP2 and RTM, are able to connect and edit DTS packages. The problem affects any user on the workstation in question. MDAC install log dasetup.log on the workstation reports a successful installation. Suggestions? Glenn Burnett Top Error occurred during creation of a DTS package by Mallika Ranjan [MS » Sat, 20 Jul 2002 01:56:27 microsoft.public.sqlserver.datawarehouse would be be better place to get your answer but here is some information that was posted some time back that might help out in your case: ... dtspkg.dll and dtspump.dll should be able to be registered.If you can't register dtspkg.dll you might try reinstalling IE - this puts on some dll's that are needed that may have been messed with. YOu can also try deleting the C:\Program Files\Common Files\Microsoft Shared\MSDesigners98 directory and reappling the SP. Do post a reply if this doesn't help your issue and we will surely get back to you. Hope this helps, Mallika This posting is provided "AS IS" with no warranties,
- This book appeals to both developers and database administrators who are faced with the common situation of having to migrate or integrate data from one location into another. While the first section of the book is designed for the beginner https://books.google.com/books?id=_mh5d8JNmYEC&pg=PA270&lpg=PA270&dq=error+occurred+during+creation+of+dts+package&source=bl&ots=0S-s_NcBve&sig=tvjOu8VAc9LBxZwbHmnfe21NSsE&hl=en&sa=X&ved=0ahUKEwjWpOrv88_PAhWZ14MKHR0qCqY to DTS, it is assumed that the reader has at least basic database...https://books.google.ru/books/about/SQL_Server_DTS.html?hl=ru&id=_mh5d8JNmYEC&utm_source=gb-gplus-shareSQL Server DTSМоя библиотекаСправкаРасширенный поиск книгПолучить печатную версиюНет электронной версииSams PublishingBoleroOzon.ruBooks.ruНайти в библиотекеВсе продавцы»Книги в Google PlayВ нашем крупнейшем в мире магазине представлены электронные книги, которые можно читать в браузере, на планшетном ПК, error occurred телефоне или специальном устройстве.Перейти в Google Play »SQL Server DTSSteve Hughes, Jim Samuelson, S. Miller, M. SantosSams Publishing, 2002 - Всего страниц: 485 0 Отзывыhttps://books.google.ru/books/about/SQL_Server_DTS.html?hl=ru&id=_mh5d8JNmYECThis book appeals to both developers and database administrators who are faced with the common situation of having to migrate or error occurred during integrate data from one location into another. While the first section of the book is designed for the beginner to DTS, it is assumed that the reader has at least basic database and programming experience. The second section is extensive coding, and is best used by someone with intermediate to advanced programming skills. The third section contains a mix of examples that will be useful to all levels of database administrators and programmers. For the readers who have been using DTS this section can be used as a reference section and help with DTS designs and usage. Unlike other resources available, this book covers data transformation in both SQL Server 7 and 2000. Просмотреть книгу » Отзывы-Написать отзывНе удалось найти ни одного отзыва.Избранные страницыСтр. xСтр. ixТитульный листУказательСодержаниеDTS in the ETL World3 DTS and Tra