Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Data loading by SSIS packages

Author  Topic 

itsmsca
Starting Member

3 Posts

Posted - 2008-08-12 : 13:24:20
Any idea how to load data into SQL server tables by replacing the old data with the new one. When i execute my package the data is inserted into tables causing duplicate rows. Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-12 : 13:34:36
Just introduce a Execute SQL Task prior to data load step which removes the data from your table based on your requirement.just use DELETE FROM YourTable WHERE Conditions..
Go to Top of Page
   

- Advertisement -