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

Posted by Satyadnet under Sql Server on 4/26/2009 | Views : 4691 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi everybody,
Please let me know the answer.
Advance thanks..

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

Latest Posts