Re: Bulkload - permissions

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

Date: Wed, 17 Mar 2004 16:43:25 -0800

What are the permissions of the process running the script? Also, Make sure
that the Sql Server account can see the schema (I think you do this). 

-- 
Irwin Dolobowsky
Program Manager - SqlXml
http://weblogs.asp.net/irwando
This posting is provided "AS IS" with no warranties, and confers no rights.
"Fred" <anonymous@discussions.microsoft.com> wrote in message
news:E5C1FD3E-12F2-46F1-BBCB-9BFE75627CD9@microsoft.com...
> I want the activex SQLXMLBulkloadobject load from a remote file identified
by an UNC like \\remoteserver\path\test.xsd. The ActiveX is running in a
script in a SQL server package.
> I get an error in the log file :
> <?xml version="1.0"?><Result
State="FAILED"><Error><HResult>0x8007052E</HResult><Description><![CDATA[Sch
ema: unable to load schema '6.xsd'. An error occurred (Unknown
Error).]]></Description><Source>Schema
mapping</Source><Type>FATAL</Type></Error></Result>
>
> the hresult seems to be in relation with logon/passwords...
> (the schema file work well on the local machine)
> the Sql Server service run with administrator's rights.
> when logged with these right, i can see the file on the shared directory.
>
> so, what is wrong ?
>
>

Relevant Pages

  • Re: automate tool to change column type?
    ... schema ahead of time. ... is the change such that you can do it with ALTER TABLE? ... but save and carefully review the script. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.tools)
  • Re: Replicating the schema while preserving existing data
    ... Can you post up the table schema ... and script out the publication and post it up. ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Migration of an Access Database. How is the best way?
    ... I am migrating an Access database to Sql Server. ... What I was initially doing is writing a script which changes the schema and ... I then planned to run this script when we go live with the SQL ...
    (comp.databases.ms-sqlserver)
  • Re: oracle grants/roles v sql server
    ... How is that done in Oracle? ... allow him/her to select from any table in any schema in the database. ... You could write a script to automate this though, ... means something very different in Oracle than it does in SQL Server. ...
    (comp.databases.oracle.server)
  • Re: Error 15401 using sp_grantlogin (not addressed by current KB articles)
    ... Restarting Windows 2000 resolved the problem for this particular account, ... confused when it sees a duplicate SID. ... > One way to get SQL Server to agree with the renamed NT ... > Preview (to ensure the script was created), ...
    (microsoft.public.sqlserver.security)