Automated migration of data from .csv file to SQLServer

This is pretty much a classic ETL[^] task

Depending on your version of SQL Server, you should look at either creating a DTS package (legacy, SQL2000) or an SSIS package

In an SSIS package, you design the steps within Visual Studio before deploying to your SQL Server - something like you've described could be achieved very easily.

Have a look into SSIS. Do you have all the tools required to use this? If so, I'd recommend using this

A simple program described here[^].

check This[^]

Here ..,

1. Develop a program to connect to .csv file
Here[^]
2. Once connection is established transfer the data onto an SQL Server automatically.
Here[^]
3. Finally delete the data in the .csv file so that it is ready to get the next fresh set of data.
Here[^]

Go through the Google before Posting a Question

you don't need to write a fully fledged program to do this. just use SQL Bulk Insert to import the data:

SQL Bulk Insert

and use a batch file to trigger the resultant sql script. you can then use the same batch file to delete the file and recreate a blank one.