fmt file was generated with ```bcp veritiadmin.tmp...
# sql
j
fmt file was generated with
Copy code
bcp veritiadmin.tmp.sedol_axioma format nul -T -n -t"|" -x -f axiomaSedolBCP.fmt -S vdbs.veriti.local
and runs like this
Copy code
bcp veritiadmin.tmp.sedol_axioma in "C:\Axioma\Downloader\output\extractedFiles\flatfile\AXWW4-MH.20221227.idm" -f "C:\Axioma\Downloader\output\axiomaSedolBCP.fmt" -F 7 -S vdbs.veriti.local -T -N
The real data file has 52K rows and needs to be imported every morning.