"m.ahrens" <mahrens@discussions.microsoft.com> wrote in message
news:24FE2A5D-BCC8-456A-80F4-A582EF399694@microsoft.com...
> Hi all
>
> I have to update an SQL Server DB Table with data from an iSeries DB Table
> with the same structure.
>
> I would like to import data everyday and i would like to update only the
> changed rows.
>
> Is there a way to do this? or is it only possible to update evertime all
> rows?
>
> thanks for your help
> m.ahrens

"Allan Mitchell" wrote:

> The ways I do it are this
>
> 1. I have triggers on the source tables that capture the changes made to
> rows and the type of change. This is captured to a table and I can use this
> table as a Source
>
> 2. Linked server. If you have linked servers between the two then you can
> query the Source for only changed rows and use that as the source.
>
>
> --
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.konesans.com - Consultancy from the people who know
>
>
> "m.ahrens" <mahrens@discussions.microsoft.com> wrote in message
> news:24FE2A5D-BCC8-456A-80F4-A582EF399694@microsoft.com...
> > Hi all
> >
> > I have to update an SQL Server DB Table with data from an iSeries DB Table
> > with the same structure.
> >
> > I would like to import data everyday and i would like to update only the
> > changed rows.
> >
> > Is there a way to do this? or is it only possible to update evertime all
> > rows?
> >
> > thanks for your help
> > m.ahrens
>
>