Share via

how to replace null value with empty "integer" in ssis derived column

Anonymous
2022-05-25T04:18:56.173+00:00

how to replace null value with empty "integer" in ssis derived column.
its flatfile source and foreign key value is zero/0. i changed to null in derived column but i have to make it black to accept in destination table

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,061 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
Developer technologies Transact-SQL

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,491 Reputation points
    2022-05-25T07:03:26.197+00:00

    Hi anonymous user.

    Try with below in the expression. 

    REPLACENULL( [your_column_name], "" )

    OR 

    ISNULL( [your_column_name]  )  ? " " : [your_column_name]

    Details you may refer to replacenull-ssis-expression.

    Regards，

    Zoe

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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.

    2 people found this answer helpful.
  2. Olaf Helper 47,436 Reputation points
    2022-05-25T06:07:17.82+00:00

    how to replace null value with empty "integer"

    What do you mean with an "empty" value?
    An integer do have a value or is null, if the target allows it by definition.
    So what for a result do you want to get for which source value?

    0 comments

Your answer

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