Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Export File Requirements

Author  Topic 

SamC
White Water Yakist

3467 Posts

Posted - 2005-08-01 : 12:21:50
I need to create an export file that is "pipe" delimited...

e.g.
Col1|Col2|Col3

Is there anyway to specify the delimiter on export?

Sam

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-08-01 : 12:27:42
there's a row and column delimiter combobox in the DTS export wizard.
is that what you need?

Go with the flow & have fun! Else fight the flow
Go to Top of Page

SamC
White Water Yakist

3467 Posts

Posted - 2005-08-01 : 12:36:07
Yes. Thanks. I should visit DTS more often.

Sam
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-08-01 : 12:39:29
LOL

Go with the flow & have fun! Else fight the flow
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2005-08-01 : 13:18:18
or save bcp as one of your fav's in BOL and use bcp with the -t option

I also built this silliness

http://weblogs.sqlteam.com/brettk/archive/2005/04/13/4395.aspx



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Go to Top of Page
   

- Advertisement -