Complex logic to be implemented in ssis- Kindly help!


  • Hi,
       I have a student table which has columns as StudentID, Enroll_date and class. If he is enrolled on Jan 2013 for Dance and then enrolled on May 2013 for Swimming means, from Jan to April, he was into Dance class.

    Similarly we want the output till the current month (august).
    I have given the i/p and the o/p. Can you please suggest me how to derive this using SSIS?
    Wednesday, August 28, 2013 7:19 PM


All replies