Share via

Visual studio 2022 SSIS OData DT_Numeric scale issue

Jabir Sageer 0 Reputation points
2023-09-12T20:28:27.7633333+00:00

I am facing a data precision problem with SSIS. When we are reading Odata feed from Dynamics 365, numeric values are skipping the decimal values, ie; Instead of 125.35 Iam getting 125 only, we ca not change the scale , it gives error message that his data type can not be changed.

Environment:

Visual studio 2022

Please help us to solve this issue.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,491 Reputation points
    2023-09-13T01:53:36.1466667+00:00

    Hi @Jabir Sageer,

    For the Decimal data type, the precision and scale are determined by the source metadata. If the source metadata does not specify the Precision and Scale properties, the data may be truncated.

    Check it out here.

    OData Source

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.