Null values in package

Question

I've created a package with SSIS, contains flatfile as source and load the data to sql server table, however it could not keep the null values, please advice.

Answer 1

Hi @sql test,

Please first check if you have chosen allow nulls in your destination table.

Secondly, you may set as below when configure the flat file source.

If these do not work, you may add a derived column transformation with the following expression to convert the blank/empty value to null.

(DT_STR,50,1252)( TRIM(Col) == "" ? (DT_STR,50,1252)NULL (DT_STR,50,1252) : Col )

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.