DTS: Begginer question

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

From: Costi Stan (stancosti_at_yahoo.com)
Date: 11/24/04 

Date: Wed, 24 Nov 2004 14:13:51 +0200

How can I use DTS to import/export tables and objects from a database.
I'm working on a tool that has to do it and I've been wondering what do I
need to program with DTS?!
Do you program the packages for import/export or the UI that executes those
packages?

As I understood, there are DTS packages stored into the server, and through
a wizard from EM you can import objects.

Many thanks in advance!

Costi Stan

Relevant Pages

  • Re: Need to recover DTS files from computer crash
    ... In terms of the DTS packagnes...if you saved your DTS ... packages to SQL Server then they will be in the msdb ... >1) To bring up a new database file into SQL Server 2000 can I just use the ...
    (microsoft.public.sqlserver.server)
  • Re: Need to recover DTS files from computer crash
    ... I will let the network admin know to restore that as well. ... > In terms of the DTS packagnes...if you saved your DTS ... > packages to SQL Server then they will be in the msdb ... or do I need to create a new database with the same ...
    (microsoft.public.sqlserver.server)
  • RE: How can We check the Relational check
    ... You can pass GVs between packages by either using the DTS object model ... "Krishna" wrote: ... > I have imported the tables from excel to my database which does not have the ...
    (microsoft.public.sqlserver.dts)
  • Re: How to read a text file really fast??
    ... > and store the data into an Access database. ... Note you can create and run DTS ... packages programatically. ... Now this helped me when using Access with a MSDE backend (I note you ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: "Class not registered" error when opening DTS package...
    ... Importing A Text File Using The DTS Wizard ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... import/export data to/from sql server 2000 and comma delimited files. ... Designer Error when trying to open my packages. ...
    (microsoft.public.sqlserver.dts)