For some special reasons, my table is created every week with a new week no. Please see attached file or screen shot for details.
I would like to output the content of this table to a .csv file via DTS package but I can't do it because the field name (week) of the table increases every week or changes every new month. In DTS, each field in the table and output field is fixed.
Please advise is there a way round for this. Or beside using DTS package, is there other methods to output the content. I can't change the table structure now.