I am writing an SSIS package and control and dataflows. I have my control flow to run with SQL just fine with my OLE DB source and SQL Server Destination.
I want to be able to pass a param or more like an "iif" statement. For example, only get this data IF the date is GETNOW()-1 > table1.datetime (or attached to a column name in a table as in example).
Iif the date is greater than or less than [table1].[datetime] then RUN THE PACKAGE if not, DON'T RUN. In the end, I want to only bring changed records into the SQL Server Warehouse Database if they exist.
Thank you for all your experts so far!!