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?

You can use a VBscript task to remove the header, by altering the text file.

Brian

I wound up using an ActiveX script to take out the header. It works great.