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 |
|
bodhansamanta
Starting Member
2 Posts |
 Posted - 2012-07-04 : 08:16:17
|
| Hi Folks !!I'm here posting one stored procedure to archive few certain folders from source path locations to the specific destinations location which are already specified in a master table.Assume, the master table contains the PATH_ID,SOURCE_PATH, DESTINATION_PATH and PERIOD as well. So, I have written the abovesaid query to move the eligible folders, checking against the corresponding Period. The folder names are like say 201104 and we have to check in that perspective. If the folder is older than the period specified against any source path, it'll automatically move to the destination path.But, here after executing the SP, It's giving a result set like return value is zero.Can anybody help me out !!Thanks,Bodhan |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
bodhansamanta
Starting Member
2 Posts |
Posted - 2012-07-05 : 05:50:05
|
[quote]Originally posted by visakh16
we do this by means of SSIS packages. We've a few automated sql agent jobs which calls SSIS packages and makes use of file system tasks to do archiving.No, I want to implement a regular stored procedure for the aforesaid purpose.Please feel free to ask any question regarding the SP. Thank you... |
 |
|
|
|
|
|
Regular Stored Procedure to archive folders.