Re: Error !!! SQL XML Bulkload Please help

From: Irwin Dolobowsky [MS] (irwind_at_mail.microsoft.com)
Date: 06/25/04 

Date: Fri, 25 Jun 2004 11:41:52 -0700

Are you possibly running two jobs at once and one can not access the file
because the other still has it open?

Irwin 

-- 
Irwin Dolobowsky
Program Manager - SqlXml
http://blogs.msdn.com/irwando
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nitin" <Nitin@discussions.microsoft.com> wrote in message 
news:75EB6BBE-9E47-4279-9D89-D2D5BC418B59@microsoft.com...
> Hi Michael
> The schedule job gets run by SQL server Agent and the SQL server agent is 
> running under administrator user. The  SQL server job is calling is COM+ 
> (in which i am using SQLXML bulkupload) and it runs under seperate user 
> which has also got the administrator permission. I dont know this happens 
> some times only.
>
> thanks for your kind support
>
> Nitin
>
>
> "Michael Rys [MSFT]" wrote:
>
>> This sounds like you run the scheduled job with less permissions than 
>> when
>> you do. Is the scheduled job running as a different user?
>>
>> Michael
>>
>> "Nitin" <Nitin@discussions.microsoft.com> wrote in message
>> news:C6033E80-4C72-44D5-B59C-3B750EE27C23@microsoft.com...
>> > Yes
>> > I did check the permission and size thats not the problem
>> >
>> > funny thing is that if i run the job explicitly it does runs properly 
>> > but
>> > if i schedule it to run automatically it gives me this error
>> >
>> > thanks
>> > Nitin
>> >
>> > "Michael Rys [MSFT]" wrote:
>> >
>> >> Did you check the obvious permission and size issues for the log file
>> >> location?
>> >>
>> >> Thanks
>> >> Michael
>> >>
>> >> "Nitin" <Nitin@discussions.microsoft.com> wrote in message
>> >> news:D780E0E2-3FA2-4F6B-BFFD-987E528682C8@microsoft.com...
>> >> > Hi guys
>> >> > I am running COM component from SQL server jobs.
>> >> > The COM component uses SQLXML bulk object to copy the data to SQL
>> >> > server.
>> >> > I do get following error. The error comes some times only some. It 
>> >> > is
>> >> > not
>> >> > consistant
>> >> >
>> >> > can anyone tell me why it is happening some times only and how to
>> >> > resolve
>> >> > it
>> >> >
>> >> > thanks in advance
>> >> >
>> >> > error :-
>> >> > Executed as user: myserver\Administrator. Error Code: 0  Error 
>> >> > Source=
>> >> > Microsoft XML Bulkload for SQL Server  Error Description: The error 
>> >> > log
>> >> > file could not be created. Make sure you have the appropriate
>> >> > permissions
>> >> > and that the ErrorLogFilePath is valid.    Error on Line 1.  The 
>> >> > step
>> >> > failed.
>> >>
>> >>
>> >>
>>
>>
>>

Relevant Pages

  • Re: Column Level Permissions Security Issue
    ... role is granted SELECT rights as in "GRANT SELECT TO RWE", then a DENY ... When working with security in SQL Server it's imperative to understand ... discusses ownership chaining: http://www.sommarskog.se/dynamic_sql.html. ... there are users who have permission to access this ...
    (microsoft.public.sqlserver.security)
  • Re: SQL CLR Sproc isnt running right
    ... did you grant rights using the SQL Server 2005 Surface Area Config tool? ... and I got a permissions error back saying DBO doesn't have permission to insert records into the table... ... but the assemblie's stored procedures do all have execute permissions set for the role that the executing user is in... ... "William Vaughn" wrote in message ...
    (microsoft.public.dotnet.framework.adonet)
  • System.Security.SecurityException with .NET 2005 Only
    ... Crystal Report from a SQL Server 2000 table. ... Friend WithEvents scnSQLConnection As _ ... The dialog box suggests clicking on "Add Permission to the Project." ... Restart the debugging session, same problem again. ...
    (microsoft.public.dotnet.languages.vb)
  • After 2003 to 2005 Upgrade Wizard, Getting System.Security.SecurityException
    ... Crystal Report from a SQL Server 2000 table. ... Friend WithEvents scnSQLConnection As _ ... The dialog box suggests clicking on "Add Permission to the Project." ... Restart the debugging session, same problem again. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: users logs off pc;dts doesnt run
    ... the job is a scheduled job that runs around 4 AM. ... SQL Server Agent runs the job. ... > I am assuming that he runs the DTS package from his machine when it run ...
    (microsoft.public.sqlserver.server)