I have a SSIS package which has the following:
Data Flow Task
- OLE DB Source (select * from table1 where DateCol <= ISNULL(@DateVar,DateCol ))
- OLE DB Destination
- DateVar variable
And I need to have a possibility to set value for DateVar or leave it empty or NULL (by default). So, it could be two cases: DateVar have a value and DateVar have no value
Is it possible in SSIS?
If so, how can I do this?
Thank you in advance!