Watch, Follow, &
Connect with Us

Please visit our new home
community.embarcadero.com.


Welcome, Guest
Guest Settings
Help

Thread: Import query does not work



Permlink Replies: 0 Threads: [ Previous | Next ]
Patricio Cerda

Posts: 122
Registered: 3/13/01
Import query does not work
Click to report abuse...   Click to reply to this thread Reply
  Posted: May 19, 2017 12:01 PM
Hi,

I'm trying to import data using RapidSQL XE from a semicolon text file to a MS-SQL database table. The import wizard worked well and generated the insert query for about 50 thousand records. The problem is that when I click on the execute button nothing happens: after some seconds showing the state of working on, the process finish without any success or error message and the table remains without those records.

I'm double checked that the data is ok for the fields of the table and I have the permission to write on this table.
If I try the same query but only with a few records then it works, but I need to import all records.
What I'm doing wrong?

This is a piece of the query showing the two first records and the last one:
--
-- TABLE INSERT STATEMENTS
--
INSERT INTO dbo.PRE_DISTRIB_VENDEDORES ( ICCID, CODIGO_TIPO_CHIP, CANAL_VENTA, FECHA_RECEP_CANAL, RUT_VENDEDOR, FECHA_DISTRIB_VENDEDOR )
          VALUES ( N'895603016665586069', N'648414', N'TEAM PORTA', N'02/01/2017 12:00:00 AM', N'19277062-9', N'02/02/2017 12:00:00 AM' )
go
INSERT INTO dbo.PRE_DISTRIB_VENDEDORES ( ICCID, CODIGO_TIPO_CHIP, CANAL_VENTA, FECHA_RECEP_CANAL, RUT_VENDEDOR, FECHA_DISTRIB_VENDEDOR )
          VALUES ( N'895603016665586070', N'648414', N'TEAM PORTA', N'02/01/2017 12:00:00 AM', N'19277062-9', N'02/02/2017 12:00:00 AM' )
go
 
...
 
INSERT INTO dbo.PRE_DISTRIB_VENDEDORES ( ICCID, CODIGO_TIPO_CHIP, CANAL_VENTA, FECHA_RECEP_CANAL, RUT_VENDEDOR, FECHA_DISTRIB_VENDEDOR )
          VALUES ( N'8956032166466767031', N'662011', N'TEAM PORTA', N'04/01/2017 12:00:00 AM', N'19338523-0', N'04/20/2017 12:00:00 AM' )
go

Best regards,
Patricio Cerda

Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02