If the data set is not that large then the effort may not be worth it. if
however it is large and the time taken to do a complete refresh is long then
I would most likely

Create a linked server of the Access database from the SQL Server and do the
comparisons on your Queries.



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"JustinW" <anonymous (AT) discussions (DOT) microsoft.com> wrote

into SQL server for reporting/analysis purposes. The data is a complete set
of all of their data instead of just new/changed data. Is there anyway to
tell the package to ignore duplicates in order to speed up the process or
should I clear all of the SQL server tables and then reload the data from
scratch?