SEO

#1 (**permalink**) 02-27-2008, 07:09 PM

How can I import an xml file to SQL 2005 at the same time every night? I
will need to create a new database first via the import after that I will be
appending to the dataabase. Then I will need to xport the data into a
different xml file and upload to my hosting system which is yahoo. All so the
original xml file is on the yahoo. store server.

I have SQL 2005 standard install on my personal work stations. When I iron
the bugs out I will be running this from our SQl 2005 Enterprise server.

Thank you

Dee

#2 (**permalink**) 02-27-2008, 07:10 PM

You can use SQL Agent to enable the scheduling of event to do the import.

Here has more info: http://msdn2.microsoft.com/en-us/library/ms189237.aspx

Or, you can just use Scheduler provided by windows OS to call a script,
which importing XML into SQL server.

Please elaborate more of what you try to do and we can help you further.

Thanks,
Shin

"Dee" <Dee@discussions.microsoft.com> wrote in message
news:9F9BEBC1-B108-4AA3-880E-D23B580159AA@microsoft.com...
> How can I import an xml file to SQL 2005 at the same time every night? I
> will need to create a new database first via the import after that I will
> be
> appending to the dataabase. Then I will need to xport the data into a
> different xml file and upload to my hosting system which is yahoo. All so
> the
> original xml file is on the yahoo. store server.
>
> I have SQL 2005 standard install on my personal work stations. When I
> iron
> the bugs out I will be running this from our SQl 2005 Enterprise server.
>
>
>
> Thank you
>
> Dee
>

#3 (**permalink**) 02-27-2008, 07:10 PM

> " I will need to create a new database first via the import after that I
> will be
> appending to the dataabase. "

Do you mean tables or do you really want to create a new database every
night on the fly? IF yes, this can be done using SMO code and putting it
into a scripting task

--
Sincerely,
John K
Knowledgy Consulting
www.knowledgy.org

Atlanta's Business Intelligence and Data Warehouse Experts

"Dee" <Dee@discussions.microsoft.com> wrote in message
news:9F9BEBC1-B108-4AA3-880E-D23B580159AA@microsoft.com...
> How can I import an xml file to SQL 2005 at the same time every night? I
> will need to create a new database first via the import after that I will
> be
> appending to the dataabase. Then I will need to xport the data into a
> different xml file and upload to my hosting system which is yahoo. All so
> the
> original xml file is on the yahoo. store server.
>
> I have SQL 2005 standard install on my personal work stations. When I
> iron
> the bugs out I will be running this from our SQl 2005 Enterprise server.
>
>
>
> Thank you
>
> Dee
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

automation