Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dhani
Posting Yak Master
132 Posts |
 Posted - 2008-11-13 : 11:21:17
|
| in my project i have a package which reads data from file and process then stores to oneTable (ex: empDateTable)this above package needs to be execute 10 to 20 times a daybut on every day morning(start of the day) the table needs to be clean (truncate all data in the table)i can workout this with Execute Sql Task but what i am asking is where can i define this (i mean in another package in the same project) or completely new projectbecause this cleaning needs to be done only once during start of the daywhat can i do, please share any plansThanks in advanceBest Regardsasin |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-13 : 11:25:47
|
| You don't need separate packages for it. Put truncate table command in SQL job and schedule it to run one time. Also remove truncate table logic from previous one. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-13 : 11:25:53
|
| if this needs to done only once per day, then just configure another job to execute once a day which executes truncate table statement. |
|
|
|
|
|
|
how to schedule a project in two differnt schedule