 | |
ERROR: while opening DTS package
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
ERROR: while opening DTS package -
02-06-2004
, 08:56 AM
#2
| |||
| |||
|
|
ERROR: The selected package cannot be opened. The DTS designer has been closed. I was able to open DTS packages before. But all of a sudden I am not able to open any of them. The designer closes with the above mentioned error. I am told that my SQLDTS.dll is corrupt. How can I fix it? Please advise TIA Sandeep |
#3
| |||
| |||
|
|
-----Original Message----- What says your dll is corrupt SQLDTS.dll? Is that one of ours? Do you mean dtspkg.dll? You could try reregistering the dlls listed here Redistributing DTS with your program (http://www.sqldts.com/default.aspx?225) Does this happen when opening designer itself with no package? What version + SP level of DTS are you running? Is the package on your local box or are you retrieving it from another place? If another place then what is the version + SP level there? -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Sandeep" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:b9ea01c3ecc1$6c2393a0$a001280a (AT) phx (DOT) gbl... ERROR: The selected package cannot be opened. The DTS designer has been closed. I was able to open DTS packages before. But all of a sudden I am not able to open any of them. The designer closes with the above mentioned error. I am told that my SQLDTS.dll is corrupt. How can I fix it? Please advise TIA Sandeep . |
#4
| |||
| |||
|
|
Its actually dtspkg.dll which is corrupt. yes, it happens any time (with or w/o DTS) when I try to open Designer. I have already tried the suggested resolution in article (http://www.sqldts.com/default.aspx?225).I am unable to unregister the DLL as well. ERROR is as following. DLLUnregisterServer in "C:\.......\dtspkg.dll" failed. We are running SQL Server 2000. This is what I get when I run select @@version Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4) Let me know if you need more information. thanks Sandeep -----Original Message----- What says your dll is corrupt SQLDTS.dll? Is that one of ours? Do you mean dtspkg.dll? You could try reregistering the dlls listed here Redistributing DTS with your program (http://www.sqldts.com/default.aspx?225) Does this happen when opening designer itself with no package? What version + SP level of DTS are you running? Is the package on your local box or are you retrieving it from another place? If another place then what is the version + SP level there? -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. www.SQLDTS.com - The site for all your DTS needs. I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Sandeep" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:b9ea01c3ecc1$6c2393a0$a001280a (AT) phx (DOT) gbl... ERROR: The selected package cannot be opened. The DTS designer has been closed. I was able to open DTS packages before. But all of a sudden I am not able to open any of them. The designer closes with the above mentioned error. I am told that my SQLDTS.dll is corrupt. How can I fix it? Please advise TIA Sandeep . |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.