Hi All,

I have found my self an answer for this problem.

I used Unpivot transformation. It solved my problem.

Please refer :

http://dbantics.blogspot.com/2009/07/unpivot-transformation-with-multiple.html

Thanks.

Bhaskar

Hi Grace,

Could you please elaborate the details of the issue.

What exactly you are doing in SSIS?

Thanks.