Dear All, We have around 40 databases on a server and we need to export data from them as per a complex query to a .csv file. Since this is a routine job I need to automate it. Presently I run the Export data wizard on each database, copy paste the query and it creates a single .csv file per DB. In order to automate I think of the following scenarios: scenario1 Start the wizard from a stored proc(user or system).The info needed to run the wizard will be stored in a text file which will be read by the proc and provided to wizard. scenario2 Have a stored proc which will do everything like below: for each database_name(read from a txt file) do Use database_name(read from a txt file) Go @sql = " select gdf.etert from rt ......."(complex query) Execute @sql; --Create a database_name.csv file and export the data retrieved with column names. Go Which of the above scenario is best for the data transfer? Depending on which is the best pls provide the code. If there is any other better method of doing it pls provide details. I am looking at a DB solution without creating any appln(exe) for it. The experts need to provide a working solution. Thanks for ur efforts. Today's knowledge is too little for tomorrow's job