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