|
I need to setup a SQL script to run nightly. The script starts by creating temp table and it builds up one after the other, and finally dumps the data into a table. The next day it drops the data from the same table, and creates a new data with the same table name. I’m using SQL Server 2005. My question is what would be the best way of achieving this. Please Help. Thanks!
(comments are locked)
|
|
Simply create a SQL Agent job to run the script you have. http://msdn.microsoft.com/en-us/library/ms189237.aspx Can this be done using SSIS?
May 28 '10 at 04:32 PM
sharon
Not really the same thing. The SSIS package would be something that you would also schedule as for execution via the SQL Agent too.
May 28 '10 at 04:45 PM
Fatherjack ♦♦
(comments are locked)
|
Your answer
