Possibly save 1 hour of your time: There are times when you need to import csv file with a nullable integer column. However, when you use the SQL Server database >> Task >> Import wizard, you will notice the result shows integer 0 instead of null values when the import csv file shows blank.
There is no feature on this wizard to treat blanks as nulls. The alternative is to use SQL Server Integration Service (SSIS).
But you can do it via an SSIS package to do ETL on the data from the CSV file into a SQL Server database.
You can use Data Flow Task. Inside the Data Flow Task, you can have a Flat File Source and an OLE DB Destination.
Click on OLD DB Destination, and there is option to Keep nulls.
If you don’t know SSIS, you can always use the import data feature. In the last step, there is an option to Save SSIS Package and choose File System and the next screen will ask where you want to save. After you saved, then you can load that into a SQL Server Integration Services project.