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
 General SQL Server Forums
 New to SQL Server Administration
 exporting sql data

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.
Go to Top of Page
   

- Advertisement -