>Thanks I used the below command to create a csv file, and i see when i excetured on the status bar shown the counts reached full count and said created file, but i am not seeing the file in the c drive.
>
>once after i run the below script from command window do i need to run any other script to make the file appear , seems like somewhere it is struck in memory or cache. when i searched also couldn't find the file.
>
>COPY TO "c:\test.csv" type DELIMITED
>
>Thank you very much.

No, but using windows 7 or above versions you can not write directly on C:\ drive root like that :-)
Better try to export it in some folder.