And the question is .. ?
In the SSIS OleDB destination is an option "Remain NULL values".
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
And the question is .. ?
In the SSIS OleDB destination is an option "Remain NULL values".
Hi @youness hamdane,
Please check if you have chosen keep nulls in destination like shown below.
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.