import does not recognize delimiter ~

#1

I have a text file to import to sql server 2005. The fields were separated by ~
when I use the import from management studio, I specified the delimiter as
~. I ended up only getting one big column as the entire row for the
destination table.
What is the problem here?

Thanks in advance for your help.

Pingx

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

import does not recognize delimiter ~

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

import does not recognize delimiter ~ - 06-16-2009 , 04:47 PM