sql server dts: Inserting data into all the relevant tables -- sql server dts

Inserting data into all the relevant tables

anm
4/27/2006 2:52:02 AM

sql server dts:

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?

Re: Inserting data into all the relevant tables

Walter Mallon
4/27/2006 2:15:49 PM

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
[quoted text, click to view]