Pipe delimited files

Last Post 21 Aug 2008 11:05 AM by sschmid4. 3 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
sschmid4
New Member
New Member

--
20 Aug 2008 09:27 AM
I am trying to create an output file from a table where the delimiter is a pipe instead of a comma. How can I make a file pipe-delimited?
sschmid4
New Member
New Member

--
21 Aug 2008 11:05 AM
I am trying to use SSIS to create the export file. bcp is not an Option for me. I was hoping to set the delimiter coming out of an SSIS data flow destination.
SQLUSA
New Member
New Member

--
22 Aug 2008 03:55 AM
Edit the destination item in Connection Managers.

In the columns tab, you can set the Column Delimiter option.

Let us know if helpful.

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server Training, SSAS, SSIS, SSRS: http://www.sqlusa.com/
sschmid4
New Member
New Member

--
22 Aug 2008 06:40 AM
That worked. I chose a text file output with pipe delimiter. Thanks.


Acceptable Use Policy
---