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 |
|
Nith
Starting Member
17 Posts |
 Posted - 2010-06-02 : 01:31:03
|
| Dear buddies,I am trying to convert a table from Sql server 2005 to flat file/text file.I used this SQL and getting error as given below.SQL: bcp database_name.schema_name.table_name out output.dat -c -U user_id -S computech01\sqlserver2005Error: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '.'.I tried this and didn't work either:bcp [database_name.schema_name.table_name] out output.dat -c -U user_id -S computech01\sqlserver2005error:Msg 179, Level 15, State 1, Line 1 Cannot use the OUTPUT option when passing a constant to a stored procedure.Please guide me.Thanking in advance.Nith |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2010-06-02 : 17:27:40
|
| the first option should work.. try enclosing the server name in quotes..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
Error using bcp