Why doesn't VS Integration services not honor Null?

Venkat Venkataramanan 76 Reputation points


I am cretaing an Integration project using VS 2019.

When processing a flat file, the project does not seem to leave the imported value to Null when no data is found.

For example, if it's a CHAR or VARCHAR, it creates an empty String; if it a integer, the imported value is 0.

I would like to see NULL In both instances.


SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,485 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Monalv-MSFT 5,896 Reputation points

    Hi @Venkat Venkataramanan ,

    Please refer to the following link and pictures:

    Retain NULL values vs Keep NULLs in SSIS Dataflows - Which To Use?



    Best Regards,


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues in November--What can I do if my transaction log is full?
    Hot issues in November--How to convert Profiler trace into a SQL Server table?