Thanks for reply. I wish I can ask my client to provide different file. Is there any I can get the output that I need? through t-sql or SSIS?

Thank You.