How To Tackle Not Null Constraints In Ole Db Destination In Ssis Package?

I'm new to SSIS Package. I want to transfer data from source to destination database which has different table structures. My Data Flow is from OLE DB Source to OLE DB Destination

Solution 1:

You can use derived transformation to assign 1 when the TenantId is null

ISNULL([TenantId]) ? 1 : [TenantId] 

Similary for AddedBy column add an expression as 1 and for AddedDateTime column as GETDATE()