DTS on SQL 2000

DTS on SQL 2000

Post by Ralf Huels » Thu, 11 Dec 2003 07:39:24

Hi !

i have a little bit experience with SQL and with Access(vba).
on a Windows 2000 Server with SQL 2000 i was trying to use DTS rather than
somehow programming to solve my task.

To do:
a) several data sources (test CSV, text TAB, Access, SQL 2000, SQL 7) data
should be collected
b) from every source, there may be names in one column. the source-tables
have to be search one after another and new names have to be added to the
outpout tabel, as long as they don exist allready
c) at last, all sources will be searched for rows with a column containing
the names, and if found other columns(content/value) are addedd in the
output tabelle

a) no problem, all scources are collected in local tables, all with the same
a output-table of same structure is although in place and empty
b): here, i think, i got a problem that my brain just freezez.. i tried to
user the sql-querie-builder in the dts-taks to set up something like:
- add all "Name" in Table2 into "Name" in Table1, as long as they don
exisit there allready
for some strange reaso, i can join and set clauses like i want.. i never get
what i want.. i can choose beetween all and no "Name"
c) is there a way to do the following in DTS/Querri:
- if Table3."Name" = Table1."Name" and Table3."Ort" <> NULL (and
Tabelle.1"Ort" equal or not equal NULL) --> Ort intp Table 1 as update


Ralf Huelsmann

1. SQL Server 2005 DTS Migration Tool (SQL Server 2000 to SQL Server 2005)

2. Edit SQL 2000 DTS package from SQL 2005

I would like to be able to edit SQL 2000 DTS packages from the SQL 2005
Server Management Studio however I get the message "SQL Server 2000 DTS
Designer components are required to edit DTS packages. Install the special
web download 'SQL Server 2000 DTS Designer Components' to use this feature".

I have installed the DTS Designer Components and this works on some PCs but
not on others.

I have also tried the steps outlined in KB917406 and that does not help

What do I need to do to get this work consistently?

3. migrate sql 2000 DTS to sql 2008

4. DTS a view results from SQL Server 2000 to SQL Server 2005

5. sql 2000 dts designer in SQL 2005

6. SQL 2000 DTS to SQL 2005 SSIS

7. Migrate DTS Package from SQL Server 2000 to SQL Server 2005

8. How to open sql 2000 DTS package in sql 7?

9. SQL Server 2000 DTS Pkg logs on SQL Server 2005

10. SQL Server 2000 DTS Designer Components on SQL 2005 64-bit

11. DTS package migrated from sql 2000 to sql 2005

12. sql server 2000 dts designer components on sql 2005 server

13. DTS between SQL 7 and SQL 2000

14. Running SQL 2000 written DTS against SQL 7

15. DTS & copying between SQL 2000 & SQL 2005 (job fails when scheduled)