Hi,

Without knowing the frequency of importing your options are varied.

A DTS package works very well to import the raw data into a 'staging table'. You can even 'clean' the data using a package.

You can use a scheduled job to import and clean the data.

I would definitely recommend putting the raw data into a separate table before manipulating it. This means you don't have to be too specific with the initial import.

Regards

Graeme