Invalid data for type "numeric". RRS feed

  • Question

  • Hi All,

    We have a process in the ETL where the Ingress Data( Source ) will be loaded into our SQL Server DB ( Destination ). i am getting an error saying Invalid data for type "numeric" while loading a big table of 120 columns and 9 million Rows. So can anyone help me out on how do i find the row which is having the bad data. Please Help..!

    Thanks in Advance..


    Balaji - BI Developer

    Tuesday, January 5, 2016 3:12 PM


  • Hi Andy,

    Thanks for the Reply. But i have been using the a Stored procedure in the ETL in which i have to load around 50 tables one by one. So we have used a stored procedure to do this. Is there any alternate to find the bad data.


    Balaji - BI Developer

    If you're using Stored procedure then why not handle bad data inside it itself. Do the data type, length etc validations in SQL itself and capture error records in your log table with column information

    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Wednesday, January 6, 2016 10:03 AM

All replies