sql server dts: Can anyone help with this problem

We have a SQL Server 2000 Enterprise Edition (SP3) on Windows 2000 Server SP3

When creating a DTS package through Enterprise Manager we get a 'DTS Designer Error' dialog box filled with squares and then find that nearly all of the Data Sources are missing from the connection menu (only Data Link and Other Connection remain). If we have a package that uses Excel or Access as source/destination, they don;t pick up the connections properly and the jobs fail

I have tried to reinstall the SQL server from scratch but get the same problem. Also checked the MDAC version (2.7) and compared the ODBC drivers with another server and they match

Is there any way of re-registering data source connections manually? or can anyone shed any light on the problem. Tecnet donesn;t seem to have any information, nor sql book sonline

Any help I can get would be appreciated

regard

I think the connection icons will come from the DTS dlls but the connections
will be in MDAC.

have you tried reinstalling MDAC?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
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


[quoted text, click to view]
Designer Error' dialog box filled with squares and then find that nearly all
of the Data Sources are missing from the connection menu (only Data Link and
Other Connection remain). If we have a package that uses Excel or Access as
source/destination, they don;t pick up the connections properly and the jobs
fail.
[quoted text, click to view]
problem. Also checked the MDAC version (2.7) and compared the ODBC drivers
with another server and they match.
[quoted text, click to view]
can anyone shed any light on the problem. Tecnet donesn;t seem to have any
information, nor sql book sonline.
[quoted text, click to view]

I am having the same exact problem and it is not allowing me to reinstall?

---
Posted using Wimdows.net NntpNews Component -