Sorry for the delay, think the problem may be in the history table timestamp, I've had trouble getting that to initialize correctly.

But before changing that, try this to make...

ok, that's good. Let's try this next to see if the stored procedure can be run by itself.

-- get the @FromLSNDate date

use [CDCDW]

go

exec [spgGetCDCHistoryLastLSNDate] @cdcTable='dbo_contract'

go

-- get the @ToLSNDate date

use [CDCDemo]

go

exec...

Am gussing it has something to do with the From or To LSN values, do you get any data back if you run this query directly against the CDCDemo database,...

Unless the database table structures are changing, switching an SSIS job from one server to another is pretty straight forward. The configuration information for the database connections should be stored...

yes, DDL changes are not captured for existing CDC change tables. The DDL statements are saved in the cdc.ddl_history table for what that is worth.

When a DDL statement is...