anyone with answer ?

Thanks Phil.

Gosta, it feels a lot better to know that others have issue as well and its just not I and my skills 😛 !

I can now conclude that the...

Emily, want to write thanks again.

I had to implement your suggestion in order to import another Excel file.

I had to increase the 'TypeGuessRows' to 1000 since there were many records...

Thanks Steve.

I am getting the excel sheet from the other team so could not try what you had suggested.

Thank you very much Emily. I wanted to try the below thingy...

you are right, I am in wrong forum, however, its SSRS 🙂

Thanks for your time!

Thanks for the reply.

You are right, its a typo 🙂

Arun: Thanks for the help.

Dave : Thanks, I did not state the problem clear enough. My bad.

I have to group by col1 and YYYYDD.

So basically, I need two groupings but...

Thanks SwePeso!

Thank you all, for your help.

Modified the queries and added one index (a composite one) which has increased the performance unbelievably.

Thanks a ton!!!

The following is the piece of code :).

WHILE (@i < 2)

BEGIN

SELECT *

FROM Table1 T1

JOIN Table2 T2

ON T1.var1 = T2.var1

AND

CASE @i

WHEN 0 THEN T1.var2 = T2.var2

...

Hi,

I did the same with the help of 2 script tasks, one inside the foreach loop task and the other one, outside.

Thanks

Hi kbatta,

I implemented your idea and I am happy that it works.

I am stuck at another point now.

Is there any way that I can find out that the for each...

Thanks Kbatta. I will try it out.

Thanks you all for your ideas.

I will try and see if I am able to achieve the requirement.