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.
