DTS export to text

#1

Using a sql server connection to text file transfer, I
want to end each row with a Pipe CHR(124), carriage return
CHR(13), and a line feed CHR(10). How do I do that? I'm
doing the package with the GUI.

#2

In message <05fa01c4edb5$6efb8f60$a601280a (AT) phx (DOT) gbl>, anonymous poster
<anonymous (AT) discussions (DOT) microsoft.com> writes

Quote:

Using a sql server connection to text file transfer, I
want to end each row with a Pipe CHR(124), carriage return
CHR(13), and a line feed CHR(10). How do I do that? I'm
doing the package with the GUI.

Use some script to set it-

Coping with text files and abnormal column or row delimiters
(http://www.sqldts.com/default.aspx?257)
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

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

DTS export to text

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

DTS export to text - 12-29-2004 , 08:48 AM

Re: DTS export to text - 12-29-2004 , 11:41 AM