Importing text files from Unix

#1

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.

Suggestions pleaseee.

#2

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

"GaryC" <GaryC (AT) discussions (DOT) microsoft.com> wrote

Quote:

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.

Suggestions pleaseee.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Importing text files from Unix

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Importing text files from Unix - 11-11-2004 , 04:39 PM

Re: Importing text files from Unix - 11-12-2004 , 12:14 AM