Incremental Load

[aikman]

Hi,

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.

Thanks

Aikman

 

[gk53]

The simple way is something like that
in Data flow source you running SQL somthing like

select field1,
field2,
field3,
field4,
field5,
field6,
field7,
...........
fieldN
from sourceTabel

You need to change
to
Declare @LastImportDate date

select @LastImportDate = value
from ParamSettings
where where ParamID = 1 and Parameter = 'LastImportDate'

select field1,
field2,
field3,
field4,
field5,
field6,
field7,
...........
fieldN
from sourceTabel
where changeDate > LastImportDate