SetConnect

BulkImport

Database::BulkImport

Description
Import data from a datafile which was exported by BCP or ExportTable (in BCP-mode) into a table. Requires BCP utility (SQLserver).
Options
Server

Database servername.

Username
Username for database connection.
Password
Password for database connection.
Trusted Connection
BCP option. When checked a trusted-connection is established with the database-server and no username & password is required.
Disable Logging
When checked, all BCP logging is discarded.
Timeout
Timeout in seconds. If BCP is still running after the configured number of seconds it is assumed to hang and the BCP proces will be killed!
Tablename
The name of the table into which the data must be imported.
Delimiter
The delimiter character(s) which separates the field-data. Must match the character that was used in creating the datafile.
Note: in "Native Mode" delimiter is not required/used.
Input file
The datafile that will be used to import the data from. This datafile is usually created by a bcp-export or "ExportTable" in "BCP-mode".
Native
When checked, the inpufile is assumed to be in "native BCP format".
Extra commandline options
Extra commandline options for BCP.
User PowerShell
When checked, the command will be run by PowerShell.

Documentation

Release notes