I just have done the SSIS example in the tutorial document included when install SQL 2005 ENT. I have a problem that whenever I test to run, the service load all data from source with out noticing about the data (I mean it load all the data to the destination), I do it several time and it continue to load all without checking. That mean the data is dublicated when the schedule run?
I think there should be a paramete or something like that to help the engine just load the new data to the destination. Could you help please?
Thank
Hi Cao Van,
Ofcourse when you run the package every time it means you are inserting duplicate rows. To avoid this, I have two familiar methods
1) Truncate the destination table, everytime when you load the data from source and populate the detination table. (This is always time consuming process)
2) Use Look up concept to filter out the duplicates.
Thanks
Subhash Subramanyam
|||In other words, you are the responsible of putting enough logic to avoid loading duplicate rows in your destination. Subhassh suggestions are very valid. For the first one you can use an execute sql task in control flow, right before the data flow to perform the TRUNCATE. For the second option, make sure you search the forum; there have been many discussions around that, actually in the first page of the forum, there is a sticky post that talks about it.
sql