Home Forums Data Warehousing Integration Services SSIS check if file was already loaded ? RE: SSIS check if file was already loaded ?
Raunak Jhawar
SSCoach
Points: 15701
More actions
September 30, 2013 at 12:33 am
#1654425
For the #2 approach which you have mentioned, the design must have a dedicated staging area tables to perform an OUTER JOIN with destinations to load only new data.
Raunak J