I am trying to transfer data from a text file over to a SQL Server Table.
I am using a DTS package and the text file is fixed width. I went in and
indicated the columns in the text file, but for some reason it cannot recognize
the end of the file. The file is generated by another database and the only
row deliminator it can put in is a "End of Record." How can I tell the DTS
package to end the row when it reaches an "End of Record." Thanks.