February 28, 2006 at 5:15 am
How can we schedule a DTS package in SQL server 2005,
Secondly how can we configure the ETL process so that it collects and transfer only the NEW or UPDATED data from SOURCE to DESTINATION.
March 1, 2006 at 2:27 am
Scheduling: Use SQL Agent. And leverage the advice here: http://wiki.sqlis.com/default.aspx/SQLISWiki/ScheduledPackages.html
Only new updated data: You're going to have to use a timestamp column on the source rows to determine if they are new/changed since the last time you extracted data. This implies that you have to store the last time that you extracted data - I'll leave the decision as to how you do that up to you. This may also be of help, particularly method 2: http://www.sqlis.com/default.aspx?311
-Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply