Re: "Class not registered" error when opening DTS package...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 05/05/04 

Date: Wed, 5 May 2004 15:56:01 +0100

Have a look here

Building a Package in the DTS Designer
(http://www.sqldts.com/default.aspx?278)

And Here

Importing A Text File Using The DTS Wizard
(http://www.sqldts.com/default.aspx?276) 

-- 
-- 
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
"ganesh" <anonymous@discussions.microsoft.com> wrote in message
news:2E1DE983-B09E-4911-9A33-4ECAA45FFA1E@microsoft.com...
> Hi Roz,
>
> I am newbie to SQL DTS and looking for some sample examples of
import/export data to/from sql server 2000 and comma delimited files.  Can
you give some examples how u did it?
>
> Thanks,
> ganesh
>
>
>      ----- Roz wrote: -----
>
>      Hello, all.  Running SQL 2K.  I have several DTS packages
>      that I've always been able to open successfully without a
>      fuss.  Since a few days ago, I've been getting a DTS
>      Designer Error when trying to open my packages.  The error
>      says "Class Not Registered".  All packages do plain-
>      vanilla import/export data to/from SQL to comma delimited
>      files.  Nothing fancy, and like I said; I've always been
>      able to open them without these error messages.
>
>      Can anyone shed light on what may have caused this?
>
>      Tia!
>      Roz
>
>

Relevant Pages

  • Re: Editing DTS Packages on a 64-bit SQL Server 2005 installation
    ... The tips for running 32-SSIS packages can be extended to running 32-bit DTS ... store your DTS packages in a 64-bit SQL Server database. ... have tried installing the Web download it says to install but then I get ...
    (microsoft.public.sqlserver.setup)
  • Re: Upgrading DTS to SSIS
    ... You cannot run packages outside of BI Development Studio on a client computer that does not have Integration Services installed, and the terms of your SQL Server 2005 licensing may not permit you to install Integration Services on additional computers. ... SQL Server 2005 Integration Services (SSIS) is now a server component and is not redistributable to client computers in the same manner that the components required for SQL Server 2000 Data Transformation Services (DTS) were redistributable. ...
    (microsoft.public.sqlserver.dts)
  • RE: DTS Sucess but fails to go to next step when scheduled
    ... odbc connection to an Oracle database in my dts packages. ... My particular situation involves pulling data from an Oracle 9database into ... SQL Server 2000 -- when the Oracle database was in 8i it worked much faster ...
    (microsoft.public.sqlserver.dts)
  • DTS package permissions errors when transferring pkgs btw servers
    ... I have a DTS problem that's been giving me fits and am hoping someone here ... configuration & operate similarly to the source machine. ... Server service and SQL Server Agent logins, (they use mixed mode security - ... There are 40 odd DTS packages, which I transferred (by using Save As for the ...
    (microsoft.public.sqlserver.dts)
  • Re: "Class not registered" error when opening DTS package...
    ... Build packages in Designer ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ... Building a Package in the DTS Designer ...
    (microsoft.public.sqlserver.dts)