Thank you Mr.Steve.

But we don't receive the data in any particular order. Can this operation be done in SSIS?

Very Helpful..... Thank you....:-)

I had the same kind of problem. If we try to connect from other transformation to the lookup transformation directly it gives data type mismatch error. So i stored that...

Congrats!!!!!!!!!! Very useful Information. Thank You.:-)

Thank You....:-)

I shall try that kit. I just ordered for the same reporting services book. Thank you for the suggestion. Please do let me know how the exam was. All...

Very helpful article. Thank you.:-)

It worked.

It took 4.23 mins to execute 1,366,368 rows.(Config in my machine is less , so i think its fines.)

Thank you so much Jack it was real good help.:-)

It is ordered based on the id first and then the id2

ID ID2 Num1

1 1 5.00

1 ...

Awesome!!!!!!!!!!!:-D

It worked perfectly and it is so fast as well than my script.

Thank you so much Jack 🙂

Thank you for replying.

They are two different data regions. It uses data from different dataset. The list doesnt allow to get data from two different datasets. Is there any other...

Thank u. It worked for max or min function.

Thank you, It worked! 🙂

Thank you all,

I would like to use the script task, but i dont know how to do that. Can someone give me a sample code to import a flat file...