Re: how to load a set of 10000 xml files to a sql table?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Martin,
I'm not sure I understand your question. The following are the steps to
use to be able to use the code:
1. In enterprise manager, under the specific server you are using, click on
data transfer services and then right click in the right window and create a
new package
2. Right click -> add task -> activeX script task
3. Copy in the code and then modify for your xml files
To set the global variables i use,
close the tasks and make sure non are selected, click package -> properties
and then click the tab global variables.

i hope this answers your question. if not, could you please rephrase it?
thanks.
Ben

"Martin Bübl" wrote:

> Hi Ben,
>
> "Ben" <ben_1_ AT hotmail DOT com> schrieb im Newsbeitrag
> news:996476C5-8CC6-4444-8AC8-33FE3C601403@xxxxxxxxxxxxxxxx
> > Martin,
> > I have just written code for an ACTIVEX controled DTS that does exactly
> > what you are looking for. Ive copied and pasted the code below. Im just
> > a
> > jr. developer, but I hope this helps you. You will have to change the
> > code
> > so that it can "read" your xml files. Also, ive added some links to sites
> > that helped me accomplish this.
> >
> > Ben
>
>
> Thank you very much! I think this was exactly what I was searching for.
> Just one more question:
> Do you start the code with a ActiveX Control in a dts package as described
> in
> http://www.perfectxml.com/articles/xml/importxmlsql.asp#7 ?
>
> Regards, Martin
>
>
>
.

Relevant Pages