Skip to Content
0

Bulk Loader - job running indefinitely in long varchar fields

Dec 20, 2016 at 10:24 PM

70

avatar image

I'm having an issue with bulk loader. It seems the process copies the data to a file on the bulk loader directory but then it's not able to copy it to the target table and the job stays running.

The row log is not clear. It says integrity violations but there isn't any constraint on the target table.

I debugged as I could, and I found it's happening on fields that are on source varchar (2000) and varchar (360), so I converted them to varchar(200) in a query transform - there isn't any value on this fields above 150 anyway.

I am using binary format, so my only guess is that it is finding a tab which is the binary field delimiter and gets confused somehow.

Any ideas on this?

Thank you

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Pedro Soares Dec 22, 2016 at 12:35 AM
0

Just to correct, the job actually ends but loading 700.000 rows in 30 minutes it's not viable :\

I am using bulk loader but it seems that between creating the .dat file and copying the data into the target table it's taking too much time doing something.

Share
10 |10000 characters needed characters left characters exceeded