I have to copy about a million of records from one sql server (sql 2005) to another every day. I tried using the ssis package, but ended up locking the source table.
What would be the bestl way of doing this with out any affect on the performance of the source database.
Could I use the backup created on the source database to copy data to the dest. I wnat to copy only one day's worth of data