Refresh Table Changes made on DB to SSIS package Data Flow Items

Recently i came across a situation to add additional columns into the existing table, hence the change needs to be effected\changed in SSIS packages as well for the tasks which makes use of these tables.

In order to do that, Right Click->Show Advanced Editor..-> Click Refresh on the extreme left corner at the bottom of Show Advanced Editor window. Please refer the below screenshot of the same.

NULL values in field(s) or row(s) handling in SSIS Expression

Use the below construct to convert your field from empty string to NULL.

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

I have used the above construct in my Derived Column Transformation editor as follows:

To eliminate NULL rows we can do a check of any particular column to eliminate the row as below in Conditional Split:

ISNULL(FUND_ID) ==  FALSE 

NULL values in field(s) or row(s) handling in SSIS Expression

Use the below construct to convert your field from empty string to NULL.

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

I have used the above construct in my Derived Column Transformation editor as follows:

To eliminate NULL rows we can do a check of any particular column to eliminate the row as below in Conditional Split:

ISNULL(FUND_ID) ==  FALSE