Friday, June 10, 2011

Incremental Loads Using SSIS

Today i was thinking about doing the incremental loads and the various options that are available in SSIS.I was reading a article written on sqlservercentral.com , which is about the anatomy of the incremental loads.They talk about the new process that is available in SQL Server 2008 , called CDC.The problem in my case is that we have to do incremental loads from TerraData.
The data from TerraData has been loaded into SQL Server and now it will need to be cleansed and then it will be loaded into the datawarehouse.The Terradata is live and running.