This may not be the correct group, but maybe someone can point me in the
I am building a SQL Server 7 database for a client based on data from their
IBM mainframe. They use flat files on the mainframe no db. They provide me
an ASCII text file with fixed length fields to import into SQL. When I
attempt to connect to their file the DTS connection only seems to be able to
se the first few characters. If I open the file in Notepad and save it.
Everything works fine.
This is no real problem for me but I don't really want to leave that step in
for them to make updates in the future.
Thanks in advance for any help.