migrate + convert data from old to new db structure in SQL 2000 with DTS

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: "geronimo007" <webjc@xxxxxxxxxx>
Date: 2 Feb 2006 07:53:26 -0800

Hi, I want to migrate + convert data from old to new db structure in
SQL 2000 with DTS.

The important thing I have to do is manage the transformation (not just
a copy of data and structure), it is a transformation of data for use
in a new/changed db....

I can manage the transformation in DTS with script like VBscript or
javascript.

Is it possible to do the transformation with other tools? Selfmade
programs in c#? Or is the linking with DTS not possible and is the only
solution the use of vbscript/javascript (activeX?)?

Or are there other tools (not DTS) that can help me?

All kind of information is welcome,

Greetz,
JC

.

Prev by Date: Re: Sample ETL Advice
Next by Date: Re: How To Setup a Batch Job To Run Daily
Previous by thread: DTS failed:db3 driver missing in XP?
Next by thread: Re: Are there any SQL 2005 newsgroups yet???
Index(es):
- Date
- Thread

Relevant Pages

RE: What is DTS?
... DTS is Data Transformation Services, a set of features supplied with SQL ... Server to do data loads and transformations. ...
(microsoft.public.sqlserver.programming)
Re: import data from text file every 30 minutes
... all the 30 lines of data to SQL. ... I do not know if DTS can handle this kind ... > the DTS package which renames or deletes the text file after importing it, ... >> write a program in VBscript to do it? ...
(microsoft.public.sqlserver.dts)
Re: Ignoring certain lines in text import in DTS
... In the options tab of the properties for the transformation, ... to ignore up to a certain amount of errors. ... you could do the transformation in a vbscript inside the ... When I try to import into DTS it always fails ...
(microsoft.public.sqlserver.dts)
Re: Dynamic column mapping
... I have a DTS that reads from multiple text files importing them into a SQL ... the column lengths of the TextFile object prior to Transformation. ... DTS to use the default mapping it uses when I enter the Transformation ...
(microsoft.public.sqlserver.dts)
Re: Resultat eines SQL Statements in eine Textdatei speichern
... in einer Textdatei gespciert werden. ... Welche Buttons muss ich im DTS benutzen. ... Du machste iene Verbindung zu Deinem SQL Server und eine zu einer ... In der Transformation trägst Du als Quelle Dein Select-Statement ein. ...
(microsoft.public.de.sqlserver)