Hi


I have a SQL sript that inserts information from one table into another
in the same DataBase.

Is it possible to do this in a DTS package because i need to schedule
this task.

Many Thanks

AQ





*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

In message <O$W1tKSaEHA.3996 (AT) TK2MSFTNGP12 (DOT) phx.gbl>, AQ Mahomed
<aq786 (AT) shoecrazy (DOT) co.za> writes
If this is just a T-SQL script why not schedule it directly with SQL
Server agent?

You could put in a DTS package, using a connection and an Execute SQL
Task, then schedule the package.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org