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.
Microsoft SQL ServerMicrosoft SQL Server 2008SQL
Last Comment
Mark Wills
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Hi Chokka,
Any more information to share ? Questions ? Error Messages ?
Any more information to share ? Questions ? Error Messages ?
When i tried by passing with the folder path - I am getting syntax error - I am running the query in SQL 2012