Multiple Streams to a Single SQL Bulk Loader
Posted: Fri Oct 08, 2004 11:47 am
We seem t obe expreiencing intemittent data loss using the SQL bulk loader. One factor the might be contributing is that we have multiple streams of data feeding into the bulk loader stage directly. Has anyone seen this problem before. I am open to changing jobs to load multiple strams into a link collector and then a single strema to bulk but I don't want to do all of that work if this is not a problem situation.
Any comments would be appreciated.
Also, the data lost appeas to be distinct commit failures as they are in multiples of our commit interval (10,000 rows). It's 4 streams going to the bulk loader and only one stream appears to be loading all data consistantly.
Thanks.
Any comments would be appreciated.
Also, the data lost appeas to be distinct commit failures as they are in multiples of our commit interval (10,000 rows). It's 4 streams going to the bulk loader and only one stream appears to be loading all data consistantly.
Thanks.