Skip to Content
avatar image
Former Member

Bulk Loader - job running indefinitely in long varchar fields

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Dec 22, 2016 at 12:35 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded