How to remove duplicates rows in SSIS data flow task from a Flat file source or Excel source, Rawsource

Hi , Using a simple trick you can easily eliminate duplicate rows when using Flat file or Excel source or Raw source or any where in the Data Flow task























Simple and easy trick you can using any where in the Data Flow task

Thank you

SQLJUNKIESHARE

Advertisements

One thought on “How to remove duplicates rows in SSIS data flow task from a Flat file source or Excel source, Rawsource

  1. Pallavi says:

    What if we have many columns in source and we want all of them in destination table, but we want to use ony two column’s values to check the duplicacy? DO you have any solution to this problem? its kinda urgent if you can help.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s