Thanks!

Elliot,

I like the solution you posted above (implement a timestamp), and query for destination tables for the last update timestamp prior to running the SELECT query. Two questions:

1) ...

Does the SSIS commit each update to a table, or perform a single commit at the end of all updates?

Thanks,

Kevin

Here is the create table statement ... I probably used the wrong terminology above; I want a clustered primary key:

CREATE TABLE [dbo].[Test](

[PK1] [int] NOT NULL,

[PK2] [int] NOT NULL,

[Data] [varchar](50) NULL,

...