| Author |
Topic |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2011-10-03 : 14:08:25
|
| Hi,I need to export 9 sql server tables data to pipe delimited text file.I tried to use import/export wizard, but I can't export more than one table at a time.So just wondering is there any BCP script that I can use for export all 9 at a time. Appreciate your help.Thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-03 : 14:14:18
|
| export all tables data to single text file or 9 files?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2011-10-03 : 14:45:18
|
| 9 tables to 9 files, each table is different |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2011-10-03 : 15:45:55
|
| Thanks!I need a sample BCP command, export sql table data to pipe delimited file. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2011-10-04 : 12:56:51
|
| above command throwing error'-c' is not recognized as an internal or external command,operable program or batch file.Please advise. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
laddu
Constraint Violating Yak Guru
332 Posts |
Posted - 2011-10-04 : 15:22:05
|
| I successfully exported data into pipe delimited text file. What if I need the column names in the first data row. Appreciate your help.bcp Db1.dbo.t1 out c:\t1.txt -Sserver1\instance1 -T -t"|" -c -r\r\n |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
BCP