locked
Missing Sort transformation RRS feed

  • Question

  • I was surprised today. I was working on a package and using sort tranformation. I use it every day. Suddenly today it was missing in the transformation list. I checked everywhere in the menu but couldnt find it.

    Does anyone went through such a scenario. Please let me known

    Thanks

    Friday, January 27, 2012 12:47 AM

Answers

  • sometimes same thing happened with me.

    please follow some steps:-

    1. right click on Control flow items in toolbox

    2. click on Choose items

    3. it will show all the control flow and data flow transformation.

    4. select (check the check box) the transformation from that wizard and click ok, 

    it will come into your toolbox, then you can use.


    jeevesh fuloria
    • Marked as answer by Harry Jaj Friday, January 27, 2012 6:01 PM
    Friday, January 27, 2012 5:29 AM
  • Please mark the applicable replies as the answer and the thread is closed
    Arthur My Blog
    • Marked as answer by Harry Jaj Friday, January 27, 2012 6:00 PM
    Friday, January 27, 2012 5:33 PM

All replies

  • What version of SSIS is this? 
    https://twitter.com/#!/SamuelVanga
    Friday, January 27, 2012 1:18 AM
  • You will see it when you are inside a Data Flow Task clicked on the canvas (free outer space of it).
    Arthur My Blog
    Friday, January 27, 2012 1:26 AM
  • sometimes same thing happened with me.

    please follow some steps:-

    1. right click on Control flow items in toolbox

    2. click on Choose items

    3. it will show all the control flow and data flow transformation.

    4. select (check the check box) the transformation from that wizard and click ok, 

    it will come into your toolbox, then you can use.


    jeevesh fuloria
    • Marked as answer by Harry Jaj Friday, January 27, 2012 6:01 PM
    Friday, January 27, 2012 5:29 AM
  • Thanks guys. i found it
    Friday, January 27, 2012 5:03 PM
  • Please mark the applicable replies as the answer and the thread is closed
    Arthur My Blog
    • Marked as answer by Harry Jaj Friday, January 27, 2012 6:00 PM
    Friday, January 27, 2012 5:33 PM