chokka
asked on
SQL Bulk Copy Export - Output to Export file, Tab delimiter
Having a trouble on doing bulk copy export - I want to export a table data to text file output having tab as delimiter.
bcp "SELECT * FROM DatabaseLog" queryout TestingBulkCopy.txt -c -T
I am trying either on SQL 2008 or SQL 2012.
bcp "SELECT * FROM DatabaseLog" queryout TestingBulkCopy.txt -c -T
I am trying either on SQL 2008 or SQL 2012.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
possibly dont have write access to the root of C:\
try creating a folder first and if need be right click to go into properties / security and allow access.
what was the error ?
try creating a folder first and if need be right click to go into properties / security and allow access.
what was the error ?
ASKER
Incorrect syntax near queryout - This has nothing to do with folder path permission
ASKER
I tested the syntax in SQL 2012 and SQL 2008, I get incorrect syntax
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi Chokka,
Any more information to share ? Questions ? Error Messages ?
Any more information to share ? Questions ? Error Messages ?
ASKER
When i tried by passing with the folder path - I am getting syntax error - I am running the query in SQL 2012