How to truncate table every month last day midnight 11:59pm

Posted by Satyadnet under Sql Server on 4/26/2009 | Views : 2465 | Status : [Member] | Replies : 1
Hi everybody,
Please let me know the answer.
Advance thanks..




Responses

Posted by: Vuyiswamb on: 4/27/2009 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
Good Morning Satyadnet

What you need an SSIS hosted in a Job. Create an SSIS Job and write your Sp that Trunace the Table and go to your SQl and create a Job that run Montly on the Last day and it will run it. here is the info about SSIS
http://www.developer.com/db/article.php/3497511

http://msdn.microsoft.com/en-us/library/ms169917.aspx


And here is the Info on how to create a Job

http://www.codeproject.com/KB/aspnet/Schedule__Run__SSIS__DTS.aspx

http://support.microsoft.com/kb/918760/

http://www.exforsys.com/tutorials/sql-server-2005/sql-server-2005-administrative-tools.html

Thank you for Posting at Dotnetfunda


Vuyiswa Maseko

Thank you for posting at Dotnetfunda
[Administrator]

Satyadnet, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response