To extract distinct part numbers from an Excel sheet using an SSIS package

 

🛠 Steps in SSIS to Get Distinct Part Numbers from Excel

1. Add an Excel Source:

   • In your Data Flow Task, drag an Excel Source.
   • Configure it to point to your Excel file.
   • Select the sheet or named range that contains the part numbers.

2. Add a Sort Transformation:

   • Drag a Sort Transformation into the Data Flow.
   • Connect the Excel Source to the Sort.
   • In the Sort editor:
     • Check the box for the Part Number column.
     • Check Remove rows with duplicate sort values — this will give you distinct part numbers.

3. Add a Destination:

   • Drag a destination (e.g., Flat File Destination, OLE DB Destination, etc.).
   • Connect the Sort output to the destination.
   • Configure the destination to store the distinct part numbers.

4. Run the Package:

• Execute the package to extract and store the distinct part numbers.