0 Replies Latest reply on May 4, 2018 10:40 AM by Ray Shi

    MSSQL datatype date/datetimeoffset read as varchar

    Ray Shi 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?

      https://kb.informatica.com/faq/7/Pages/19/517555.aspx?myk=EBF-7908

      https://kb.informatica.com/solution/23/Pages/61/510239.aspx?myk=data%20object%20data%20type%20sql%20server%20datetime

       

      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?