"Sandeep" <anonymous@discussions.microsoft.com> wrote in message
news:b9ea01c3ecc1$6c2393a0$a001280a@phx.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

"Sandeep" <anonymous@discussions.microsoft.com> wrote in message
news:c03501c3ed0a$d2c4e200$a401280a@phx.gbl...
> 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@discussions.microsoft.com> wrote in
> message
> >news:b9ea01c3ecc1$6c2393a0$a001280a@phx.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
> >
> >
> >.
> >