automation

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

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" wrote in message

> 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
>