youness hamdane 0 Reputation points

I've created an ETL with SSIS, that contains ODBC source as source and OLEDB destination as destination, without any transformations between them, when the package is executed, ssis replace null values by blanks, in the destination.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,132 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,496 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 42,576 Reputation points

    And the question is .. ?

    In the SSIS OleDB destination is an option "Remain NULL values".

  2. ZoeHui-MSFT 34,591 Reputation points

    Hi @youness hamdane,

    Please check if you have chosen keep nulls in destination like shown below.

    User's image

    If this do not work, try to add DerivedColumn with below expression.

    ColumnName == "" ? NULL(DT_WSTR,50) : ColumnName


    Zoe Hui

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