It would be helpful if you posted a small piece of the .dat file you want to make a csv. Most of the time these kinds of conversions are pretty simple but you need to know the data you are working with.

I need to copy the dat file from one unix box to another unix box at daily 2:00AM and it should be copied as csv file using SSH.

For eg:From server2 it should connect to server 1 and it should get the test.dat file from server1 and it should be converted to test.csv and it should be copied in server2 using SSH. Thanks Abhishek Srivastava

The easiest way to do this would be to set up a user on both boxes and install the right ssh key so that it can use ssh without a key. Then set up a cron to run at 2 every day. This can be done with a very simple .sh file.

I m able to convert the .dat to .csv file now, but while running the script its asking for password, if ssh is enabled means it wont ask password???, I m not sure about it, please let me know the same.

Weather is there any possiblity to run the script without giving the password??