RE: SQL XML

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: mvp (mvp_at_discussions.microsoft.com)
Date: 02/04/05 

Date: Fri, 4 Feb 2005 10:33:01 -0800

It is also not working.
Do i have to install anything additional to the sql server box.

Thanks
"Alejandro Mesa" wrote:

> Try,
>
> Set objXBulkLoad = CreateObject("SQLXMLBulkLoadLib.SQLXMLBulkLoad")
>
>
> AMB
>
>
> "mvp" wrote:
>
> > Hi Mike,
> > yes i tried it, still doesnt work same error.
> >
> > Activex component can not create.
> >
> > pls let me know,
> > thx
> >
> >
> >
> > "Mike Epprecht (SQL MVP)" wrote:
> >
> > > Hi
> > >
> > > Have you tried not specifying the object version?
> > >
> > > Set objXMLBulkLoad = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")
> > >
> > > Regards
> > > Mike
> > >
> > >
> > > "mvp" wrote:
> > >
> > > > Hello,
> > > > I am trying to load bulk xml into database table using
> > > > following ActiveX script in DTS package
> > > >
> > > > Function Main()
> > > >
> > > > Dim objXBulkLoad
> > > > Set objXBulkLoad = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad.3.0")
> > > >
> > > > objXBulkLoad.ConnectionString = "provider=SQLOLEDB.1;data
> > > > source=usmeadmterptdev;database=GTEReporting;uid=pathami1;pwd=pathami1"
> > > >
> > > > 'objXBulkLoad.KeepIdentity = False
> > > >
> > > > 'Optional Settings
> > > > objXBulkLoad.ErrorLogFile = "c:\temp\Timeheader.LOG"
> > > >
> > > >
> > > > 'Executing the bulk-load
> > > > objXBulkLoad.Execute "c:\temp\xml\TimeHeader.xsd",
> > > > "c:\temp\xml\TimeHeader.xml"
> > > >
> > > > set objXBulkLoad = Nothing
> > > >
> > > > Main = DTSTaskExecResult_Success
> > > >
> > > >
> > > > End Function
> > > >
> > > > and it doesnt work. it throws that
> > > > Activex component can not create.
> > > >
> > > > Pls help me, do i need to install anything on the server where my sql server
> > > > is installed.
> > > >
> > > > thanks
> > > >
> > > >
> > > >
> > > > Expand AllCollapse All
> > > >

Relevant Pages

  • RE: Insert Statement Bloating Log
    ... "Alejandro Mesa" wrote: ... > AMB ... >> Hi Mike, ... >> Here is the DDL ...
    (microsoft.public.sqlserver.programming)
  • RE: sp_who
    ... Iam aware of that.I just wanted to know if there is any other difference. ... Otherwise why should sql server have sp_who,when there is sp_who2? ... "Alejandro Mesa" wrote: ... > AMB ...
    (microsoft.public.sqlserver.programming)
  • RE: Column xxxxx is constrained to be unique. Value n already
    ... I used the Enterprise Manager SQL Profiler... ... "Alejandro Mesa" wrote: ... > to sql server. ... > AMB ...
    (microsoft.public.sqlserver.programming)
  • Re: HasChanges returns false for one row, true when more than one
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... "Mike G Burton" wrote in message ... dataset has a single row, but True if the dataset has multiple rows. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: simple collaboration enable ?
    ... Listen to Mike, ignore the monkey trying to figure ... > throttling on more than 5 concurrent connections). ... > c) not restricted to WSS databases only ... > SQL Server 2K) ...
    (microsoft.public.sharepoint.windowsservices)