Pipe delimited files

Last Post 21 Aug 2008 11:05 AM by sschmid4. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
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.
You are not authorized to post a reply.

Acceptable Use Policy