sqlstud (9/25/2012)
Thanks Phil..Forgot to inform that i need to use SSIS 2005. So that i can schedule it in SQL Server Agent job to run on daily basis.
How do we transfer data using SSIS 2005
Regards
SqlStud
Oops - I didn't notice the forum - I should have guessed.
Are the databases on different servers? If not, SSIS is overkill here - why not just create a stored proc which does the transfer and schedule that in SQL Agent?
If they are on different servers and you don't want to use a linked-server approach, the SSIS process is similar:
1. Set up a MaxId variable with package scope.
2. Use an ExecuteSQL task to populate the variable with the max ID from the target table.
3. Create a dataflow which selects the rows from the source table using the maxid as a parameter to limit what is selected and map it to the target table.
Job done.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.