SSIS unable to handle Numeric with 30 precision

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.

Answer 1

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

Answer 2

Thanks Arthur for pointing out the link.