SSIS Null value for Integers

Question

Hi ,

I am trying to load data from a flatfile to SQL Table. I have a condition where if there are blank values for fields then I have to upload null in the tables and if there are values then i need to convert them to integer and upload to the tables.

I was using data conversion task but can any one suggest how to handle the null value in derived column.

Thanks, Kannan

Answer 1

0

I guess you can use the expression in the derived column something like

TRIM([YOURSTRINGFIELD]) == "" ? NULL(DT_NUMERIC, «precision», «scale») : (DT_NUMERIC, «precision», «scale»)[YOURSTRINGFIELD]

answered Jan 05 '12 at 03:30 AM

Usman Butt
13.8k ● 6 ● 8 ● 14

Hi thanks for your reply , I tried this but I was able to insert only 0 , but i need null values in my db tables.

Jan 06 '12 at 04:43 AM aRookieBIdev

Sorry about it . What u suggested works fine, Thanks again

Jan 06 '12 at 05:10 AM aRookieBIdev

(comments are locked)

SSIS Null value for Integers

Follow this question

Related Questions