sql server dts: Importing text files from Unix -- sql server dts

Importing text files from Unix

GaryC
11/11/2004 2:39:03 PM

sql server dts: I created a DTS to import a text that is FTP'd from a Unix server. I am not
having the common problem with the carraige return character. Instead I am
having a difficulty getting the text driver to recognize each column. The
file is, from what i'm told, space delimited. The file only has 3 columns,
but I only get one long string when I preview it.
For the row delimiter I have tried "Tab", CF/LF, CR, LF etc... nothing seems
to work.

Re: Importing text files from Unix

Allan Mitchell
11/12/2004 6:14:21 AM

Grab a hex editor and look at in here and see what the file thinks it is.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com

[quoted text, click to view]