Thanks for replying.

The destination database is a Standard 2008 SQL

I would like to create a sql agent job that would run every 10 minutes. The job would check for new records in a table on a remote database (linked server already created), if exist the job would import the new records to destination database.

From destination server SSMS, I've tried connecting to remote Express database and selecting Task/Export to create an SSIS package, I would supply a manual select statement ("select top 1000 * from "servername".DBname.dbo.table order by Created desc). On finishing the SSIS job creation the job would run and updates the new records on destination DB. However, when I rerun the job from SSMS, it doesn't work.

Preferably I would like to just add the new records not latest 1000 rows and encountering duplicates.

Thank You for your time,

nuchbcc