Re: Can DTS read a file as one big blob?
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 03/15/04
- Next message: Mike: "Attaching 6.5 db files"
- Previous message: Tibor Karaszi: "Re: Performance Degradation on SQL 2000"
- In reply to: John Peterson: "Re: Can DTS read a file as one big blob?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 15 Mar 2004 09:09:12 -0700
Yup....the SQLXML bulk load object is part of SQLXML. It's
an add-on or additional component to install. I've used
SQLXML Bulk Load in ActiveX scripts to import XML files into
the relational tables.
The SQLXML OLEDB provider that comes with it also supports
inserting XML data - but I haven't messed with it and don't
know much about it other than it exposes the functionality
through ADO. There is also a managed provider to work with
.Net
The help files that come with it are pretty good and have
examples, samples that can be used to test out
functionality. You may want to download and install it on
your PC to see if it works for you. Excuse the long link and
watch out for line wrap:
http://www.microsoft.com/downloads/details.aspx?FamilyId=CA1CC72B-6390-4260-B208-2058C0BFD7DE&displaylang=en
-Sue
On Mon, 15 Mar 2004 08:53:49 -0700, "John Peterson"
<j0hnp@comcast.net> wrote:
>Thanks Sue!
>
>Is the SQL XML Bulk Load object model part of the SQLXML package? I'm not wholly familiar
>with SQLXML -- my impression is that it's an add-on to SQL Server, and I know the initial
>reaction to our Hosting department will be to understand *why* it's necessary for us to
>install that on the Production servers. But, if it's the right thing to do, they'll
>oblige.
>
>I had thought to easily leverage some of the built-in XML features of SQL Server, and I
>think I could get DTS to invoke a SP that does some manipulation with OPENXML(), but I
>wasn't sure how to get DTS to potentially squirt the contents of the XML file into a NTEXT
>parameter to the SP.
>
>
>"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
>news:8idb50lj18hs2hopcvr11c5inrfs0gns2d@4ax.com...
>> Hi John,
>> Not sure what you need to accomplish or what exactly process
>> the file means but with XML files, another option is to use
>> SQL Server 2000 Web Services Toolkit or just install SQLXML.
>> You can use the SQL XML Bulk Load object model to import XML
>> files. You could write this in an ActiveX script task in
>> DTS.
>>
>> -Sue
>>
>> On Sat, 13 Mar 2004 18:46:48 -0700, "John Peterson"
>> <j0hnp@comcast.net> wrote:
>>
>> >(SQL Server 2000, SP3a)
>> >
>> >Hello all!
>> >
>> >I've got a pretty simple XML file that I'd like to process with DTS. I understand that
>> >DTS doesn't have native capability for XML, so I was wondering if I could still use DTS
>to
>> >read in the entire source file and pass that into a stored procedure as a TEXT
>argument?
>> >
>> >Thanks for any help you can provide!
>> >
>> >John Peterson
>> >
>>
>
- Next message: Mike: "Attaching 6.5 db files"
- Previous message: Tibor Karaszi: "Re: Performance Degradation on SQL 2000"
- In reply to: John Peterson: "Re: Can DTS read a file as one big blob?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
