Is it possible to import a flat file, and only get selected columns? I am using the SQL Management Studio import wizard, and when I tell it to skip the column, it simply deletes the headers, and shifts everything down, making a total mess of everything.
If I have four columns, and only want to import columns 2 and 3. How do I go about doing that.
I am sure I can do it by editing the flat file, but this is something I am trying to automate that will be delivered nightly.
Any help would be greatly appreciated.