Bulk Insert Stops Halfway Through

#1

Hi,

I have a problem with one of our SQL Servers.

I was loading a text file (w/DTS) that has 7903 records. Exactly half way
through it stops without warning and no indication that anything went wrong.
The resulting table always has either 3952 or 7903 records. I've done this
several times with the same source file, destination table, and DTS package.
Either all the records load or only exactly half.

I need to find out why this is happening. I've checked the server logs and
didn't find anything helpful..

Any help is appreciated.

TIA,
Bryan

#2

Id say BCP it from DOS and see what happens.,

"Bryan Bullard" <reply (AT) to (DOT) group.com> wrote

Quote:

Hi,

I have a problem with one of our SQL Servers.

I was loading a text file (w/DTS) that has 7903 records. Exactly half way
through it stops without warning and no indication that anything went
wrong.
The resulting table always has either 3952 or 7903 records. I've done
this
several times with the same source file, destination table, and DTS
package.
Either all the records load or only exactly half.

I need to find out why this is happening. I've checked the server logs
and
didn't find anything helpful..

Any help is appreciated.

TIA,
Bryan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Bulk Insert Stops Halfway Through

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Bulk Insert Stops Halfway Through - 10-25-2004 , 10:44 AM

Re: Bulk Insert Stops Halfway Through - 10-25-2004 , 12:20 PM