locked
SSIS unable to handle Numeric with 30 precision RRS feed

  • Question

  • Hi,

    I searched for microsoft document which says that the maximum size of Numeric till 38 precision. Today, I tried Numeric with 30 precision and I got "The value was too large to fit in the ADO NET Source.Outputs" error message.

    I found that with ADO.NET, SSIS is only supporting till 29 precision while with ODBC, SSIS is supporting till 38 precision. Is it a defect on part of ADO.NET or have I gone through incomplete documentation.

    Please help.

    Thursday, July 6, 2017 9:50 AM

Answers

  • Hi Vikas,

    I saw this post that appears to be a bug

    Using OLEDB instead eliminates this issue.

    I do not know if you are on a more recent SSIS build.

    In general, you posted too few details to be of more help.


    Arthur

    MyBlog


    Twitter

    • Marked as answer by Vikas.Garg Friday, July 7, 2017 5:58 AM
    Thursday, July 6, 2017 1:30 PM

All replies

  • Hi Vikas,

    I saw this post that appears to be a bug

    Using OLEDB instead eliminates this issue.

    I do not know if you are on a more recent SSIS build.

    In general, you posted too few details to be of more help.


    Arthur

    MyBlog


    Twitter

    • Marked as answer by Vikas.Garg Friday, July 7, 2017 5:58 AM
    Thursday, July 6, 2017 1:30 PM
  • Thanks Arthur for pointing out the link.
    Friday, July 7, 2017 10:48 AM