Importing a text file

#1

I am trying to import a file that is space delimited and new line as the row
delimiter. Is it possible to import a file with a space delimiter via DTS -
I tried a few things and was not successfull. We are running SQL 2000.

thanks
Meenal

#2

When creating package, select file is Delimited, then select other in the
Specify Column Delimiter Dialog and enter a single space.

"Meenal Dhody" <meenal_dhody (AT) hotmail (DOT) com> wrote

Quote:

I am trying to import a file that is space delimited and new line as the
row
delimiter. Is it possible to import a file with a space delimiter via
DTS -
I tried a few things and was not successfull. We are running SQL 2000.

thanks
Meenal

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

Importing a text file

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

Importing a text file - 09-08-2005 , 09:01 AM

Re: Importing a text file - 09-08-2005 , 01:39 PM