GPSPOW
asked on
Using BCP to output file as ANSI as UTF-8
net use P: \\pmcfs\groups
bcp "select * from livedb.dbo.tbl_RCA_DAILY_T XN_HEADERS " queryout "\\pmcfs\groups\ACCOUNTING \RCA_DAILY _TXN_HEADE RS.csv" -T -SPTM-DR01 -w -t^|
bcp "select * from livedb.dbo.tbl_RCA_DAILY_T XN_DETAIL" queryout "\\pmcfs\groups\ACCOUNTING \RCA_DAILY _TXN_Temp. csv" -T -SPTM-DR01 -w -t^|
copy \\pmcfs\groups\ACCOUNTING\ RCA_DAILY_ TXN_HEADER S.csv + \\pmcfs\groups\ACCOUNTING\ RCA_DAILY_ TXN_Temp.c sv "\\pmcfs\groups\ACCOUNTING \CHI\Daily TxnData\rc a_p1_mt_da ily_txn_"% date:~10,4 %%date:~4, 2%%date:~7 ,2%".csv"
net use P: /DELETE
I use the above in a batch file to output my SQL tables to a pipe delimited file. Now the thrid party vendor wants the output pipe delimted but in an ANSI as UTF-8 format. Is there a way to modify the above code to guarantee this?
Thanks
Glen
bcp "select * from livedb.dbo.tbl_RCA_DAILY_T
bcp "select * from livedb.dbo.tbl_RCA_DAILY_T
copy \\pmcfs\groups\ACCOUNTING\
net use P: /DELETE
I use the above in a batch file to output my SQL tables to a pipe delimited file. Now the thrid party vendor wants the output pipe delimted but in an ANSI as UTF-8 format. Is there a way to modify the above code to guarantee this?
Thanks
Glen
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The author did not get a solution from here, but he got a very good direction from angelII's comment. It is advised that author accept his own comment as answer without giving points to anyone. That will help anyone looking for the same problem.
ASKER
Method is invalid.