Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    1

    Unanswered: DTS (Oracle to SQL Server 2000)

    I am trying to convert an application database from Oracle to SQL Server 2000. I am using Data Transformation Services utility provided by SQL Server. I am converting data on table-by-table basis. However, whenever I convert DATE fields (form Oracle) into DATETIME fields (to SQL Server 2000), my tasks fails. Does anyone knows the reason and, more important, a solution to this problem ?

  2. #2
    Join Date
    Apr 2002
    Posts
    5

    Oracle to SQL Server

    Hi

    I'm also working with an Oracle Database.

    In my configuration it works.
    I used a Transform data task and the transformation I used is a copy column.

    So

    Oracle:
    numeric/field1, datetime/field2 >> source in Transform data task

    SQL Server 2000:
    numeric/field1, datetime/field2 >> destination in Transform data task

    Transformations: let SQL Server do automapping, copy column.

    Greetings
    Jon@s

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •