Toad World® Forums

Import to SQL server - no error file?


#1

I just noticed that there is no option for error files in the SQL server import
template.
Any chance this can be available before launch?


#2

Lunch may be a bit tricky. How about dinner?

CR72044 was created for this issue.

Shawn


#3

There is a technical issue for adding an error file for SQL Server. Oracle and
DB2 have bulk import facilities that provide us with the exact rows that errored
and why. I have not found an equivalent for SQL Server. In DB2 we are using
BulkCopy and with Oracle we are using arraying binding. Does anyone know of
something like this we can use for SQL Server? Without this we have to go back
to inserting one row at a time which really slows things down.

Debbie


#4

I’m using the data export wizard to generate output in the sql format for
a result set.

The options set are:

Check system resources

Fully qualify object name

Only quote object names if needed

Use uppercase keywords in inserts

The problem is the statement will not execute without throwing error:

[IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0204 - tbName in dbname type
*FILE not found

INSERT INTO " dbname ".“tbName”(“column1”,“column2”,“column3”) VALUES ( 1 ,
‘text’ , ‘text’ ) ;

Uncheck Only quote object names if needed

Closer…but the problem is the statement will not execute without throwing
error:

[IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0204 - tbName in dbname type
*FILE not found

INSERT INTO dbname .“tbName”(column1,column2, column3) VALUES ( 1 , ‘text’ ,
‘text’ ) ;

How can I get here?

INSERT INTO dbname .tbName(column1, column2,column3) VALUES ( 1 , ‘text’ ,
‘text’ ) ;

Thank You