Skip to main content

Questions tagged [bcp]

Microsoft SQL Server's bulk copy utility

Filter by
Sorted by
Tagged with
14 votes
1 answer
6k views

Optimising BCP performance for BLOB data

I'm the process of planning the live migration of a 2TB database to partitioned tables. The system is broadly speaking a document store, the majority of the space being allocated to LOBs of between ...
Mark Storey-Smith's user avatar
8 votes
2 answers
3k views

Can I bulk insert into an empty page-compressed table and get full compression?

I have a lot of large tables (around 10 million wide rows) which need to be regularly loaded into SQL Server 2016 for read-only reporting. I would like these tables to be as small as possible on disk, ...
Caitlin M. Shaw's user avatar
6 votes
2 answers
17k views

Insert custom header row in BCP output

Long story short we have a database here that manages some employee data such as email, first name, last name, etc. Our company bought into this SAP Based expense report system :| that needs an ...
JonH's user avatar
  • 289
1 vote
3 answers
4k views

SELECT Data Set Using Stored Procedure with BCP Error

All, I have a BCP export query. It is failing with the useless error mesage on BCP usage: usage: bcp {dbtable | query} {in | out | queryout | format} datafile [-m maxerrors] [-f ...
MoonKnight's user avatar