I have a file that has duplicate names in the header. I need to import the file. I know that I can import it without headers, but I would rather keep the headers, Is there any way to programmicly change the file header names. I can have them be like Accountant and Account2, for example. Or is there away to import it and change it to import it into a table. This could be in SQL or SSIS or what ever you suggest.
Any ideas I would appreciate it.