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

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

Date: Wed, 5 May 2004 20:47:35 +0100

To be honest the best way of doing this (few people build packages from
scratch I think) is

1. Build packages in Designer
2. Save to VB .bas modules
3. Have BOL handy for reference
4. Always bookmark www.SQLDTS.com
5. Play.

I would maybe "Google" for stuff as well but besides that I think you are
set. 

-- 
-- 
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:76CD32AE-9DE2-4B2B-B285-703144813482@microsoft.com...
> Thanks Allan for very informative sites.  Can you please give some other
sites having detailed information on DTS object model like creating
connections, packages, Datapumps task, bulkinserts tasks, steps etc as I
want to write programs in vb.net
>
> Cheers,
> ganesh.
>
>      ----- Allan Mitchell wrote: -----
>
>      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: Where is DTS Designer?
    ... >Quote from SQL Server Books Online: ... >"You access DTS Designer through SQL Server Enterprise Manager, ... Local Packages, Meta Data Services Packages and Meta Data. ...
    (microsoft.public.sqlserver.dts)
Loading