SSIS Script Component, Allow Null values
- by user2471943
I have a SSIS package that I am programming and my script component won't allow null column inputs. I have checked the box to keep nulls in the flat file source component. My program is running well until my script component where I get the error "The column has a null value" (super vague, I know). The column currently throwing the error is an "int" valued column and is used for aggregations in my script.
I could make the null values 0s or to say "NULL" but I'd prefer to just leave them blank.
Any advice on how to handle this problem would be greatly appreciated! Thanks in advance!
I am using SQL Server BIDS 2008.