Hi!
I have set up an OLAP cube for a scorecard application. For this the
administrator imports data to several SQL tables from Excel (in order to get
fact tables and dimension tables). My problem is that they sometimes add
KPI:s which mean that they add a column in a Excel file. When using my first
DTS package that I have created using the wizard it is not able to recognize
the new column in the Excel file since the wizard hard codes this.

What I want to create is a DTS package that actually reads the column names
in the Excel file and then creates the SQL table according to these columns
each time the package is executed. Sequently the transformation should be
mapped between the columns both old and new.

I could really use some advice on how to approach this problem.

Thanks,
Erik