Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Towards the innovative SQL ideas
Browse by Tags · View All
sql server 124
sql 123
ms sql server 118
ms sql 117
database 108
tsql 80
#SQL Server 78
t-sql 74
#sql 71
sql server general 66

Archive · View All
April 2011 14
July 2011 12
May 2011 12
August 2011 11
June 2011 10
September 2011 8
December 2011 6
November 2011 6
September 2013 5
June 2013 5

SSIS - Archive files based on number of files configuration in SQL Server

Mar 4 2012 12:00AM by Paresh Prajapati   

Hope you read earlier posts to archive files which are older as per days and you liked them. Recently i was asked by my friends to delete the files bases on <n> number of files, not based on days. Such a way we can keep <n> number of files every time and rest files get archived. I will give you an example here as i  have three folders and want to keep different number of files in each folders only. Says keep 3 files in BackupFolder1, keep 2 files in BackupFolder2 and keep 1 file in BackupFolder3. So how can we achieve it? Continue Reading...

Tags: #sql, #sql Server, Archive, database, ms sql, ms sql server, retention, SQL, SQL Scripts, SQL Server, SQL Server General, SSDT, SSIS,


Paresh Prajapati
6 · 23% · 7533
4
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

"SSIS - Archive files based on number of files configuration in SQL Server" rated 5 out of 5 by 4 readers
SSIS - Archive files based on number of files configuration in SQL Server , 5.0 out of 5 based on 4 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]