Lidou123 (1/10/2013)
Phil,I will use it like a staging table.
After data in the table, I will use them easily with SSIS and T-SQL.
If the column names and datatypes change every day, it may be easy but it will also be manual. If you're happy with that, you might as well keep the entire process manual and just use the import wizard.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.