Auto Import into sql from a Tab Delmited flat file

i was wondering if there was a way to auto import my file everyday and then process the deminsions and cube i have made in the analysis service program

I suggest looking at the integration services feature in SQL 2005 and DTS in SQL 2000.

You could also use BCP or Bulk Insert.

All of these are covered in books online.