Share via

ETL with SSIS

youness hamdane 0 Reputation points
2023-05-04T12:31:37.03+00:00

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 Integration Services
SQL Server | Other
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,586 Reputation points
    2023-05-04T13:01:26.5966667+00:00

    And the question is .. ?

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

  2. ZoeHui-MSFT 41,536 Reputation points
    2023-05-05T01:38:29.5833333+00:00

    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

    Regards，

    Zoe Hui

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

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.