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

Advertisement

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:
    Reply

    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:

Gravatar
WordPress.com Logo

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

Facebook photo

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

Cancel

Connecting to %s