I created a table with 43 columns. The table contains char, varchar, and tinyint datatypes. I am running on Windows Server 2008 R2 64bit. The file contains two rows and is comma separated. The file is BCP output from MSSQL. When I tried to bulk load into the table from a file with a COPY INTO command I got an unhelpful message. "failed to import table" How can I find out why the import failed?
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 2013-11-27 09:03, Colin Foss wrote:
I created a table with 43 columns. The table contains char, varchar, and tinyint datatypes. I am running on Windows Server 2008 R2 64bit. The file contains two rows and is comma separated. The file is BCP output from MSSQL. When I tried to bulk load into the table from a file with a COPY INTO command I got an unhelpful message.
"failed to import table"
How can I find out why the import failed?
Which version of MonetDB are you using? I seem to remember fixing a problem where the actual failure message wasn't propagated to the level where the error was reported. - -- Sjoerd Mullender -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.15 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQCVAwUBUpWvuT7g04AjvIQpAQITogP+OQ+gRf0cqd+F3yCpXIqP9SqxTKBkYaCd rpAs9L9UFVpihJAUxZCdpAcaXSf0WeWYSeTWFo6OAfBUtA+CSLnmKN2Nz2iaGQmR +hO/EseEEzPswsfaXeIoL6k/9PpYSLr9SsPUoa7lx3iwCuUv18xgJx5O3x5FV6pB ADERtGZHLP8= =0FsK -----END PGP SIGNATURE-----
participants (2)
-
Colin Foss -
Sjoerd Mullender