text/column delimiter

#1

Is it possible to set

..ConnectionProperties("Column Delimiter")

to a character besides one of the four available in the connection dialog?

#2

Have a look here

Coping with text files and abnormal column or row delimiters
(http://www.sqldts.com/default.aspx?257)

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Tom Spitzer" <tspitzer (AT) ecwise_stripme (DOT) com> wrote

Quote:

Is it possible to set

.ConnectionProperties("Column Delimiter")

to a character besides one of the four available in the connection dialog?

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

text/column delimiter

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

text/column delimiter - 11-10-2003 , 12:14 AM

Re: text/column delimiter - 11-10-2003 , 09:33 AM