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