sql server dts: I have a file with fixed-length fields and a table with matching length
columns. I'm trying to use DTS to import the file but find that if a
record in the file is a bit short, DTS doesn't import it. For example,
if I had fields of widths:

FirstName 5
LastName 4
Company 10

the file:

John Doe Acme Inc.<NL>
Jane Doe<NL>

would fail to load the second record. This means that I'd have to pad
the file before loading it:

John_Doe_Acme Inc.<NL>
Jane_Doe_________<NL>

(_s provided to show spaces) which is just sad. I'm sure this must be
a _very_ common problem but formulating the right query for google has
proven difficult. help?

TIA - erick

Hello ekkis,

May be this article can help in this instance?

http://www.databasejournal.com/features/mssql/article.php/1462341


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

[quoted text, click to view]