June 17, 2004 at 4:43 am
hi everyone
i want to extract data to a file (txt or csv). The way i was thinking of doing it was to use access, setup an odbc link to a table, setup a query and a macro.. and simply schedule the macro to run ...and pipe the result to a file.. sounds messy but it works ok.
ideally i'd luv to tinker with a one of script, either jscript or perl..that i can either schedue or simply click and run simply..
does anyone have any other ideas or have a script i can use as a guide???
thnx
tony
June 17, 2004 at 6:06 am
Why not use DTS or BCP. You can schedule either in sql server agent.
Far away is close at hand in the images of elsewhere.
Anon.
June 17, 2004 at 5:26 pm
what is DTS and BCP? some kind of scripting language?
I will look into itn and see if i can use it... thnx for responding
tony
June 18, 2004 at 1:53 am
DTS is Data Transformation Services and allows the copying and transformation of data between databases and or files.
BCP is Bulk Copy Program and allows the transfer (in or out) of data between sql server and text files. It is fast but has no data transformation.
Both are detailed in BOL (Books Online).
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply