Re: DTS designer error and all tasks are missing

From: Simon Lenn (simonlenn_at_yahoo.com)
Date: 06/01/04


Date: 1 Jun 2004 14:44:42 -0700

rboyd@onlinemicrosoft.com (Rand Boyd [MSFT]) wrote in message news:<y7FTjj$REHA.2260@cpmsftngxa10.phx.gbl>...
> Another option is to install a named instance of SQL Server 2000. This will
> force a complete rewrite of the DTS components. I do not believe they all
> get removed when SQL Server is unistalled. If this fixes the problem, you
> can then remove this instance without affecting DTS.
>
> Rand
> This posting is provided "as is" with no warranties and confers no rights.

How can i reregister the DTS dlls and how do I reinstall the MDAC.

Also, how do I create a different named instance I thought SQL sets it
up by default to the server name.

Thanks
Simon



Relevant Pages

  • Re: DTS designer error and all tasks are missing
    ... Another option is to install a named instance of SQL Server 2000. ... force a complete rewrite of the DTS components. ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL 2000 - Connection Error with DTS Packages
    ... After I changed all SQL Server 'Database Connection' steps in each of my DTS ... Package" option when you right click a DTS package name in ME. ...
    (microsoft.public.sqlserver.dts)
  • Re: vb.net dataTbl can DTS read?
    ... then using ADO to read/write the data to Sql Server. ... like what DTS does with Text Files, MS Access data, etc. ... Right now I am experimenting with writing the data from ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server DTS From Sybase
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > DataPump is used interchangeably with the transform Data Task ergo not the> ExecuteSQL task ... >>>> I want to import data from a Sybase database via a SQL Server DTS ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server DTS From Sybase
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > DataPump is used interchangeably with the transform Data Task ergo not the> ExecuteSQL task ... >>>> I want to import data from a Sybase database via a SQL Server DTS ...
    (microsoft.public.sqlserver)