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.