locked
SSIS Mapping Float SQL Server Float Oracle - in Lookup Transformation RRS feed

  • Question

  • Hallo,

    ich habe ein Mapping Problem beim Mapping in Lookup Transformation. SQL Server Float Datentyp in Oracle Float Datentyp.

    Quelle = SQL Server: hat eine Spalte ID und zweite Spalte Flaeche(float).

    SSIS: In Lookup Transformation muss das Feld Flaeche anhand des Schlüsselfeldes ID aktualisiert werden (in Oracle Flaeche(float) überschrieben werden falls geändert!)

    Ziel = Oracle: hat eine Spalte ID und zweite Spalte Flaeche(float)

    In Lookup Transformation wenn ich das Feld vom SQL Server Flaeche(float) mit Oracle Feld Flaeche(float) mappe, kommt eine Fehlermeldung "Die 'Flaeche'-Suchspalte kann nicht zugeordnet werden, da die Spalte auf einen Gleitkommadatentyp festgelegt ist"

    Wie kann ich das Problem lösen? Hat jemand Idee?

    Vielen Dank im Voraus

    Dani

     

     

     

     

    Monday, February 6, 2012 1:05 PM

Answers

  • Hello Arthur,

    I was asking about mapping in Lookup transformation from float (sql server) to float (oracle) for updating the records.

    The problem has now been solved now.

    Thanks for asking. This was in German language:

    Best Regards

    Dani

     

     

    • Proposed as answer by ArthurZ Monday, February 6, 2012 4:57 PM
    • Marked as answer by Eileen Zhao Friday, February 10, 2012 12:37 AM
    Monday, February 6, 2012 4:03 PM

All replies

  • Dani,

    in what language is the post? Can you translate using Bing or Google?


    Arthur My Blog
    Monday, February 6, 2012 3:13 PM
  • Hello Arthur,

    I was asking about mapping in Lookup transformation from float (sql server) to float (oracle) for updating the records.

    The problem has now been solved now.

    Thanks for asking. This was in German language:

    Best Regards

    Dani

     

     

    • Proposed as answer by ArthurZ Monday, February 6, 2012 4:57 PM
    • Marked as answer by Eileen Zhao Friday, February 10, 2012 12:37 AM
    Monday, February 6, 2012 4:03 PM