I am going to import the data which is required for creating reports.
The data in the table is not easily queried, therefore I have created other
tables to extract the data from this main table.

As importing data would be a weekly procedure,I will have to overwrite the
existing data with the new data and have all the data go through to all the
sub-tables. So far I have created queries in the SQL Query Analyzer but this
would require having to manually run all the queries, how can I make all the
data in sub-tables be easily updated with the new data from the main table
rather than running queries manually?

create a dts package that uses the execute sql task to call your queries.
Remember to truncate the target tables first. All you need in the package
is a connection object and an execute sql task object.

Walter
"anm" <anm (AT) discussions (DOT) microsoft.com> wrote