Check for non numeric value and also null value in data flow and insert to zero in SSIS2008
I was a loading a huge text file into sql temp table and then loading into actual table with different field types like char to decimal ,date,currency,etc. Pkg fails after loading 150000 rows and i need to check for non-numeric and null values and then a case statements to load the column. Any help would be appreciated.
March 23rd, 2011 7:24pm

Use a conditional split to filter null values. For non numeric values you can have a derived column to convert the incoming value to numeric data type as: (DT_NUMERIC,10,4)InputCol. Also, configure the error output of the derived column component to capture the non numeric values. Nitesh Rai- Please mark the post as answered if it answers your question
Free Windows Admin Tool Kit Click here and download it now
March 23rd, 2011 7:39pm

Thank you. I will give a try and let u know...
March 23rd, 2011 10:29pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics