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.
Author |
Topic |
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2011-04-11 : 14:29:06
|
Is there any way export the sql data into pipe delimited text file.Currently we wrote scripts (joining multiple tables )and pulling the reports in to excel file, now user is asking the same report in pipe delimited as well.I know that if we want to export a table data , we can use import/export wizard and select destination as text file(comma or pipe delimited/tab) but joining multiple tables's data, how can export to pipe delmited text file. we are not configured SSRS. |
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-04-11 : 15:50:54
|
ssis or bcp will both do it without much coding.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|