2 Replies Latest reply on Nov 29, 2021 9:38 PM by Anusha P

    MSSQL datatype date/datetimeoffset read as varchar

    New Member

      Informatica BDM 10.2, developer tool.



      We have thousands of tables imported from MSSQL to informatica as data objects.

      When we were trying to use these objects in mapping as source, we found that all fileds with data/datetimeoffset data type would be read as varchar(0), then we have to manually adjust the data type one by one.



      We did found two posts here as below links, but I'm not sure why is this the case?




      So this is still an unsupported data type, or a bug, or ODBC connecting issue?

      Is there any way to adjust the datatype in a batch to reduce labor?