SQL Server Performance

SSIS and Null Values

Discussion in 'SQL Server 2008 Integration Services' started by alladiz, Feb 11, 2014.

  1. alladiz New Member

    Hi Everyone,
    I have package in SSIS. It has a execute sql task that gets some config values from a table on different server. So the SSIS package gets those config values and stores them in the variables in SSIS. These variables are used in further sql tasks as parameters.

    The issue that I am encountering is, Some of those config values are null. So whenever SSIS encounters a null value for a integer type, it converts that to 0 and passes it as 0 to further task rather than passing it as null

    If the data type of the column is date and its value is null in the config table, SSIS assigns a default value “12/30/1899 12:00:00 AM” and passes the default value as the parameter rather than the null value.

    How do I make the SSIS package pass the actual null value rather than the value converted by SSIS ?

    Thanks in advance!!

Share This Page