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)
 Deleting duplicate data on column value

Author  Topic 

Johny2706
Starting Member

1 Post

Posted - 2010-01-18 : 05:36:58
Hello,

I want to upload a flatfile into a table but I want to to delete the data first based on the DISTINCT values of the column 'Month' in my flatfile. I am new to IS. How can I do this? Which components do I have to use? I have a flatfilesource, Multicast, Aggregate, SQL command and a OLE DB Destination,
I want to fill the table after I deleted the duplicate records, so I think I need to set a flag after the deletions. How can I do this?

Thanx
   

- Advertisement -