I 've this csv file which looks fine when I open it, but when I reach to the bottom of this report I see this signature
Report Generated by
Report generated time
Name of the Company
ID, M_Name,L_Name,F_Name, Street_name,SSN,Phone1,
I remove this junk data manually and load this file into the table [SQL SERVER 2008].
Is there any way we can write a script to remove this junk values?
Please let me know if you need any thing else?