Bulk loading data to SQL Server databases
The following points may help you to configure for bulk loading from IBM® SPSS® Modeler to a SQL Server database using the External Loader option in the DB Export Advanced Options dialog box.
- Ensure that the SQL Server bcp.exe utility is installed
- The script mssql_loader.py invokes the SQL Server utility bcp.exe. Ensure that bcp.exe is installed on the server where mssql_loader.py is to be executed.
- Using spaces as delimiter does not work
- Avoid choosing space as the delimiter in the DB Export Advanced Options dialog box.
- Check table size option recommended
- We recommend that you enable the Check table size option in the DB Export Advanced Options dialog box. Failures in the bulk load process are not always detected, and enabling this option performs an extra check that the correct number of rows has been loaded.
- Blank strings
- Blank strings are exported to the database as NULL values.
- Specify the fully qualified SQL server named instance
- There may be occasions when SPSS Modeler cannot access SQL Server due to
an unqualified hostname and displays the following
error:
Error encountered while executing external bulk loader. The log file may provide more details.
To correct this error, add the following string, including the double-quotes, to the Extra loader options field:"-S mhreboot.spss.com\SQLEXPRESS"