SuperBulkCopy, or SBCP is what you had always hoped 'bcp' and 'BULK INSERT' would be like.
It is a FREE simple tool that quickly and easily loads any text file into the database.
It comes in two flavors: UI and a Console (command-line) version and does the following out of the box:
- - Automatic header detection
- - Automatic delimiter detection
- - Automatic data-types detection
- - Quoted Identifiers support (i.e. if your delimiter is comma[,] and you have this value: "hello, world" - the process will not break!)
- - Adaptive asynchronous mode for fast parallel processing
- - Very Automatic, yet provided with many different control knobs
While possible, it is never an easy task and even though we have SSIS (and Import wizard, which runs SSIS), BULK INSERT, BCP that come
out of the box with SQL Server, none of them does a good-enough job, which often leads to continuous trial & error
Screenshots (hover to zoom):
Configuration Screen - Define input parameters
Main Screen - define output parameters
Shared Repository - A powerful server management console embedded on all of our products.