Automated loading .CSVs into SQL Server

I am new to SQL Server and would be greatful for any assistance you
may be able to provide.
I have an incoming directory that recieves .csv files are regular
intervals. I need to be able to identify when these files arrive and
then load them into SQL Server into seperate tables overwriting the
current data. I was looking to use DTS, however i have never used it
before.
Could you assist or refer me to any useful sources?
Thank you in advance.
Visit at www.sqldts.com
<dipeshpatel316@.gmail.com> wrote in message
news:1170760628.739101.96140@.a34g2000cwb.googlegro ups.com...
>I am new to SQL Server and would be greatful for any assistance you
> may be able to provide.
> I have an incoming directory that recieves .csv files are regular
> intervals. I need to be able to identify when these files arrive and
> then load them into SQL Server into seperate tables overwriting the
> current data. I was looking to use DTS, however i have never used it
> before.
> Could you assist or refer me to any useful sources?
> Thank you in advance.
>