Bulk insert silently does nothing

Hi.. I am using a simple bulk insert statement which works on all our
servers except one. The servers are windows 2000 and are running
Sql Server SP4.
The bulk insert statement simply does nothing.
In query analyser, it returns
"The command(s) completed successfully." and yet returns no rowcount, error
etc
There are no events in the event log and no errors in the sql log
DTS bulk insert happily completes without doing a thing.
bcp of the same file does work however (from the server ) ..
Can someone point me in the right direction regarding DLL's etc to be
checkig please ?
Thanks DaveDid you try:
-o output_file
Specifies the name of a file that receives output from bcp redirected from
the command prompt.
"gilkida" <gilkida@.discussions.microsoft.com> wrote in message
news:894DB758-93BC-432D-8167-F05F83B2467C@.microsoft.com...
> Hi.. I am using a simple bulk insert statement which works on all our
> servers except one. The servers are windows 2000 and are running
> Sql Server SP4.
> The bulk insert statement simply does nothing.
> In query analyser, it returns
> "The command(s) completed successfully." and yet returns no rowcount,
> error
> etc
> There are no events in the event log and no errors in the sql log
> DTS bulk insert happily completes without doing a thing.
> bcp of the same file does work however (from the server ) ..
> Can someone point me in the right direction regarding DLL's etc to be
> checkig please ?
> Thanks Dave|||Sorry Chris.. probably not clear.. I am running the Sql Command Bult Insert
BULK INSERT t_BulkLoad FROM 'Some Filename"
works on every server but one... t
"ChrisR" wrote:
> Did you try:
> -o output_file
> Specifies the name of a file that receives output from bcp redirected from
> the command prompt.
>
>
> "gilkida" <gilkida@.discussions.microsoft.com> wrote in message
> news:894DB758-93BC-432D-8167-F05F83B2467C@.microsoft.com...
> > Hi.. I am using a simple bulk insert statement which works on all our
> > servers except one. The servers are windows 2000 and are running
> > Sql Server SP4.
> >
> > The bulk insert statement simply does nothing.
> >
> > In query analyser, it returns
> > "The command(s) completed successfully." and yet returns no rowcount,
> > error
> > etc
> >
> > There are no events in the event log and no errors in the sql log
> >
> > DTS bulk insert happily completes without doing a thing.
> > bcp of the same file does work however (from the server ) ..
> >
> > Can someone point me in the right direction regarding DLL's etc to be
> > checkig please ?
> >
> > Thanks Dave
>
>|||Woops, sorry.
"gilkida" <gilkida@.discussions.microsoft.com> wrote in message
news:C20BE904-1DDD-4511-ADBD-11C98CB62A98@.microsoft.com...
> Sorry Chris.. probably not clear.. I am running the Sql Command Bult
> Insert
> BULK INSERT t_BulkLoad FROM 'Some Filename"
> works on every server but one... t
>
> "ChrisR" wrote:
>> Did you try:
>> -o output_file
>> Specifies the name of a file that receives output from bcp redirected
>> from
>> the command prompt.
>>
>>
>> "gilkida" <gilkida@.discussions.microsoft.com> wrote in message
>> news:894DB758-93BC-432D-8167-F05F83B2467C@.microsoft.com...
>> > Hi.. I am using a simple bulk insert statement which works on all our
>> > servers except one. The servers are windows 2000 and are running
>> > Sql Server SP4.
>> >
>> > The bulk insert statement simply does nothing.
>> >
>> > In query analyser, it returns
>> > "The command(s) completed successfully." and yet returns no rowcount,
>> > error
>> > etc
>> >
>> > There are no events in the event log and no errors in the sql log
>> >
>> > DTS bulk insert happily completes without doing a thing.
>> > bcp of the same file does work however (from the server ) ..
>> >
>> > Can someone point me in the right direction regarding DLL's etc to be
>> > checkig please ?
>> >
>> > Thanks Dave
>>|||I have the same issue. I found this posted today.
http://support.microsoft.com/?kbid=896425
It says it's applicable to Standard Edition SP3, I too have Enterprise
Edition SP4 + hotfix.
"ChrisR" wrote:
> Woops, sorry.
>
> "gilkida" <gilkida@.discussions.microsoft.com> wrote in message
> news:C20BE904-1DDD-4511-ADBD-11C98CB62A98@.microsoft.com...
> > Sorry Chris.. probably not clear.. I am running the Sql Command Bult
> > Insert
> >
> > BULK INSERT t_BulkLoad FROM 'Some Filename"
> > works on every server but one... t
> >
> >
> > "ChrisR" wrote:
> >
> >> Did you try:
> >>
> >> -o output_file
> >>
> >> Specifies the name of a file that receives output from bcp redirected
> >> from
> >> the command prompt.
> >>
> >>
> >>
> >>
> >>
> >> "gilkida" <gilkida@.discussions.microsoft.com> wrote in message
> >> news:894DB758-93BC-432D-8167-F05F83B2467C@.microsoft.com...
> >> > Hi.. I am using a simple bulk insert statement which works on all our
> >> > servers except one. The servers are windows 2000 and are running
> >> > Sql Server SP4.
> >> >
> >> > The bulk insert statement simply does nothing.
> >> >
> >> > In query analyser, it returns
> >> > "The command(s) completed successfully." and yet returns no rowcount,
> >> > error
> >> > etc
> >> >
> >> > There are no events in the event log and no errors in the sql log
> >> >
> >> > DTS bulk insert happily completes without doing a thing.
> >> > bcp of the same file does work however (from the server ) ..
> >> >
> >> > Can someone point me in the right direction regarding DLL's etc to be
> >> > checkig please ?
> >> >
> >> > Thanks Dave
> >>
> >>
> >>
>
>