none
Data Type in Oracle is not translating in SSIS datatype RRS feed

  • Question

  • My OLDB data source in the Lookup Transformation is not converting

    When I try to join the colunms it claims the data types do not match the only differnece is the percision.??


    ORACLE
    select CAST(group_id AS NUMBER(18)) group_id  from blah blah table
    SSIS data type = [DT_NUMERIC], Percision = 38

    SQL Sever data source
    SELECT
    CAST(PRINCIPAL_ID as numeric) GROUP_ID,
    SSIS data type = [DT_NUMERIC], Percision = 18


    Monday, September 25, 2006 11:47 PM

Answers

  • The metadata of the columns being joined should have to match exactly. (same precision, same scale)
    Friday, September 29, 2006 5:43 PM