Search : in
By :

SQL or SSIS package to move files based on da

jcw, on Oct 19, 2009 7:22:49 pm BST 
 Report this message to moderators

Hello,

I have been requested to put together a job that I would like reach out to the community for some advice.

- I need to keep 1 week worth of .daily bak files at any given time in e:\SQL_BAK

- I also need to keep 3 months worth of .bak files taken 2days AFTER last business day of month end (example: last business day of Sept is the 30th so I will need to keep Oct 2nd backup for 3 months and each month after)


I currently have an accounting table that has the last business days already defined that I’m thinking I can use to query against for the last business day.



01 2009-01-01 - 2009-01-30
02 2009-02-01 - 2009-02-27
03 2009-03-01 - 2009-03-31
04 2009-04-01 - 2009-04-30
05 2009-05-01 - 2009-05-29
06 2009-06-01 - 2009-06-30
07 2009-07-01 - 2009-07-31
08 2009-08-01 - 2009-08-31
09 2009-09-01 - 2009-09-30
10 2009-10-01 - 2009-10-30
11 2009-11-01 - 2009-11-30
12 2009-12-01 - 2009-12-31



Has anyone out there ever configured anything close to this that may be able to post a code snippet? Thanks!

Configuration: Windows XP Internet Explorer 6.0

Best answers for « SQL or SSIS package to move files based on da » in :
Batch Script to Move files older than 30days Show
Using .MOV file ON Windows Movie Maker Show Using .MOV file ON Windows Movie Maker Solution Windows Movie Maker does not recognize my .MOV files Solution Windows Movie Maker natively does not recognize MOV files The solution is to convert ( MOV files into AVI files....
Find which package a file belongs Show Find which package a file belongs Third option Below is a tip of how to locate a file needed when compiling. dpkg is the "low level" under debian allowing you to manage a package (installation, removal, purge ...) underwhich other...
Delete SP1 uninstall files on Windows Vista ShowDelete SP1 uninstall files on Vista Uninstall service pack by using the Programs and Features item in Control Panel Uninstall Service Pack using the Command This tip will allow you to save more than 700 Mb on the system partition by...
Moving or copying a file with your right mouse button ShowMoving or copying a file with your right mouse button Command for right mouse button Create a file in the registry Set up of the file in the registry Command for right mouse button To move or copy your document and file to another...
[Bash]Parameters Show[Bash]Parameters Intro Example 1 Example 2 Initialize parameters Examples Example 3 Intro You can provide a script on the command line and arguments also known as parameters for its implementation. There are two categories of...
Linux - The shell ShowIntroduction to the shell The command interpreter is the interface between the user and the operating system, hence the name "shell". The shell therefore acts as an intermediary between the operating system and the user thanks to command lines...
Operating Systems - MS-DOS - Commands ShowCommand Description dir lists the contents of a folder cd changes folder cd .. parent folder md or mkdir creates a new folder deltree deletes a folder and all sub-folders copy, xcopy copies...
Ask your question Reply
They need your help