DTS Designer Error: "The system cannot find the file specified"

Greg

unread,

Jan 14, 2004, 10:45:04 AM1/14/04

to

I get a DTS Designer Error (The system cannot find the
file specified) whenever I open DTS Designer to create or
edit a package, and the task toolbar/box is empty.
Appears as though some .dll is missing or unregistered.
It was working fine, but not now. Anyone experienced
this and know how to fix it?

SQL Server 2000 with Service Pack 3a

Allan Mitchell

unread,

Jan 14, 2004, 11:48:55 AM1/14/04

to

Have a look here

Service Pack and Version Compatibility Problems
(http://www.sqldts.com/default.aspx?223)

--

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

"Greg" <gf...@kumc.edu> wrote in message
news:0a9b01c3dab5$60cf7410$a601...@phx.gbl...

Greg

unread,

Jan 14, 2004, 12:19:37 PM1/14/04

to

Thanks Allan. I believe I had seen that article. My
packages were all created with SQL Server 2000, and they
still open and appear to run fine. The problem is with
the Designer. It's missing the Task Controls--so I can't
build anything new. The connection conrols are there,
just not the task controls.

>.
>

Allan Mitchell

unread,

Jan 14, 2004, 12:50:40 PM1/14/04

to

Re-register the DTS dlls

Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)

--

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

"Greg" <gf...@kumc.eud> wrote in message
news:08a101c3dac2$95f926b0$a001...@phx.gbl...

Greg

unread,

Jan 14, 2004, 1:36:50 PM1/14/04

to

Thanks again, Allan. I had already done this with
several of the .dlls. The ones I had not yet re-
registered were

sqlresld.dll
axscphst.dll
custtask.dll
sqlunirl.dll

I did. No luck. I get the DllRegisterServer entry point
not found error when trying to register

sqlunirl.dll
sqlresld.dll
dtswiz.dll

I successfully registered

repldts.dll
dtsffile.dll
dtspkg.dll
dtspump.dll
dtsui.dll
semdts.dll
axscphst.dll
custtask.dll

Any more thoughts? One of the DBA's here says that she
has had this happen before and that replacing the whole
directory with someone's working directory always solved
it for them. Haven't tried that yet.

Greg

>.
>