How to delete text file header
I'm brand new to DTS packages and have run into a bit of a quandry. I am trying to load a text file into a database using a fixed length text file. However, the first line is a header. When I try to use the text file source task to skip the first row it actually skips the header AND the first good row. When I check the "First row has column names" checkbox SQL Server 2000 crashes with a memory error. When I do nothing, the formatting is ruined. Can anyone offer any suggestions as to how to get rid of this header?