Hi,
I intend to import the data with an SSIS package, which would load the source file from a defined location.
Please bear with me as I am quite new to SQL, still loads to learn.
Thanks in advance,
Sure, no problem.
For SSIS, in the Flat File Connection Manager, you have an option that mentions Header rows to skip. On that option, you need to set it to 2 and check the Column names in the first row checkbox.
That should handle the file if the row delimiters are consistent.
Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?
How to post data/code on a forum to get the best help: Option 1 / Option 2