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. |