One option is to use DTS , check this tutorial which gives you an overview
of the basic concept
http://www.sqldts.com/299.aspx
--

Jack Vamvas
___________________________________
Need an IT job? http://www.ITjobfeed.com




<junkmail115@gmail.com> wrote in message
news:1189789969.933601.166560@g4g2000hsf.googlegro ups.com...
> Greetings,
>
> A novice needs some advice:
>
> I am able to bulk insert data from a text file into a table. Is it
> possible to run a query and insert the results into a text file on the
> local or network hard drive?
>
> Thanks For Reading,
> Aaron
>