SSIS handling NULL and blank spaces

Question

hello i am new to SSIS and iam receiving text file created by SSIS iam using wizard to load it to oracle table but in the text file there is columns contain the String NULL and other contain blank string instead of zero length column is there an auto way to make these value to become actual null value in the table or do i have to create derived column for each one of theses cases

thank you,

Answer 1

Within an SSIS project in the SQL Server Data Tools for Visual Studio 2015/SQL Server 2016, the way to address the handling of empty columns seems to be via a property of the Flat File Source component (not certain whether space-only columns qualify):

1. Right-click the Flat File Source and choose Show Advanced Editor....
2. Select the Component Properties tab.
3. Set RetainNulls property to True (default is False).