sql server new users: SQL Newbie -- sql server new users

SQL Newbie

Jonathan
2/22/2005 5:51:02 AM

sql server new users:

Hi Everyone,

I am new to SQL and really am finding it a great product, but I want to do
something that I think would be simple but can't find anything on Technet and
wondered if anyone here can point me in the right direction:-

I am wanting to import data from a legacy database still in use straight
into SQL (which I can do Manually) before I import the data (which is purely
for ODBC & .ASP reporting) I manually delete the contents of the SQL tables
(SQL script "delete [tablename]") and then Manually import the contents from
the legacy database using the DTS.

What I want to know is how can I create an automated proecss/script or
whatever that will automatically delete the contents on a table before I set
the DTS to run?

Does any of that make sense?

Tia

Re: SQL Newbie

Steve Thompson
2/22/2005 9:37:31 AM

[quoted text, click to view]

Yes, a single DTS package would be perfect for all of these steps... You can
truncate the contents of the target table as the first step in the DTS
process.

Steve