Am a newbie in SSIS and need help with following:
Have a load and the last step in the Control Flow I update LastImportDate in a Table
update ParamSettings set
value = convert(date,getDate(),120)
where ParamID = 1 and Parameter = 'LastImportDate'
Next time I run the SSIS package I want to check LastImportDate value in that table and only load Incremental data.
Source and destination databases are on different servers
Have tried with Lookup but can´t understand how to check one cell for all rows in source table.
Have search google, but cant find any solution, I hope I have give enought info.