Why doesn't VS Integration services not honor Null?

Venkat Venkataramanan 76 Reputation points
2020-11-27T15:45:51.44+00:00

Hello:

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.

Venki

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
    2020-11-30T09:58:55.34+00:00

    Hi @Venkat Venkataramanan ,

    Please refer to the following link and pictures:

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

    43701-retainnull-ffs.png

    43674-keepnull-od.png

    Best Regards,
    Mona

    ----------

    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?