Excellent one...thanks mayank

thanks for all the replies...I got this one sorted out..by using analytical functions ROW_NUM and DENSE_RANK

Thanks guys...finally i got it..i just used 2 different connection managers and same file name..it worked out

good catch....got it...that is report requirement...we need to send as it is to our users..now i will filter that one record..

Actually it is a view..and it is defined as below

SELECT

QUOTENAME ('Call_Date', '"') as Call_Date

, QUOTENAME ('Acquisition_Date', '"') as Acquisition_Date

, QUOTENAME ('DateofRecord', '"') as DateofRecord

UNION ALL

SELECT

...

I am working in SSIS ..when it see new value i am getting below error

"[Pivot [29]] Error: The pivot key value "1/31/2015" is not valid.

OK got it..but the issue is if i run this one again next month it will not run ..because new loans will be added with end date 06/30/2015..As there will...

output should be like this

col1 col2

a ...

THANKS..It Worked