Re: Microsoft DTS help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

what type of transformations do you need?

<pradip1979@xxxxxxxxx> wrote in message
news:1120980098.525167.213120@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> I am working on migrating many Oracle tables to SQL server 2000 and
> performing column level transformations for most the tables.
>
> I am first planning to export all the Oracle tables to a staging
> database in the SQL server 2000. Then apply transforms for the tables
> and export it onto the target SQL server database.
>
> I am planning to use DTS for the migrations. I have some basic
> questions regarding DTS features:
>
> 1. There are different approaches in DTS for migrating:
>
> a. Using the Import/Export wizard.
>
> b. Data transform task/Data driven task.
>
> c. Programmatically using VB application and accessing the DTS
> libraries
>
>
> In option b, we can use Active x scripts for performing the
> transformations by creating a package.
>
> Questions:
>
> 1. Is Data transform task sufficient for my purpose? Is there any way
> Data Driven Query task can help me in this regard? Also the same for
> Parallel Data dump task? I have not read much abt Parallel data dump
> task, hence the query?
>
> 2. Is there any way T SQL help me in this regard if I go for Data
> transform task option?
>
> 2. I also feel that I need not go for VB application in this regard.
> Any comments regarding whether it is better suited than a data
> transform task will help me too.
>
> 3. Regarding creation of packages, should I create multiple packages
> for migrating each table from staging database and then link all the
> packages using conditions or a single package is fine? Will there be
> any performance implications in first case?
>
> Thanks in advance,
>
> Pradip
>


.

Relevant Pages

  • Microsoft DTS help
    ... database in the SQL server 2000. ... There are different approaches in DTS for migrating: ... Is Data transform task sufficient for my purpose? ... Regarding creation of packages, ...
    (microsoft.public.sqlserver.dts)
  • Re: temp table troubles
    ... It's an ETL (Extract Transform Load) tool that ... transformations and load the results into a SQL Server table. ... And what transform Code? ... > string rapidly exceeds its 8000 varchar limit. ...
    (microsoft.public.sqlserver.programming)
  • Re: variable in transaction
    ... The problem will arise if you change the metadata for the transform. ... Global Variables and SQL statements in DTS ... If you expose it as the same column Name each time then you will not need to ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. ...
    (microsoft.public.sqlserver.dts)
  • Re: Huge data needs to be transfer from Fixed width Text File to S
    ... 1- Transform the data, because I have to change data into Date and money from Char and I need to perform certain validation which is very hard to implement in TQSL as i am using SQL Server 2000. ... This can *really* save you time (and transaction logs size) on big data import operations, as it makes the DB log only the whole operation in the transaction logs, as opposed to logging every single row inserted. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Pivot and Transform in SQL Server
    ... SQL Server doesn't have pivot or transform functionality natively. ... > [Sub Product Code], tblExpenseCodes., First ...
    (microsoft.public.sqlserver.programming)