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.