Regarding the larger images, they used to work but the site upgrade appears to have killed them off. They are just standard DTS screenshots however. You can see more at my site where I reproduced the article
Regarding naming a new folder every day, the following should help
create some test folders
exec xp_cmdshell 'Md C:\TestDTS\Folder0001'
exec xp_cmdshell 'Md C:\TestDTS\Folder0002'
exec xp_cmdshell 'Md C:\TestDTS\Folder0003'
exec xp_cmdshell 'Md C:\TestDTS\Folder0004'
exec xp_cmdshell 'Md C:\TestDTS\Folder0005'
--try some later ones
exec xp_cmdshell 'Md C:\TestDTS\Folder0023'
exec xp_cmdshell 'Md C:\TestDTS\Folder0024'
exec xp_cmdshell 'Md C:\TestDTS\Folder0025'
exec xp_cmdshell 'Md C:\TestDTS\Folder0323'
exec xp_cmdshell 'Md C:\TestDTS\Folder1024'
exec xp_cmdshell 'Md C:\TestDTS\Folder5425'
If Object_id('tempdb..#t1') > 0
Drop Table #t1
Create Table #t1 (
Declare @path Varchar(255),
Select @path = 'C:\TestDTS\'
Select @folderPrefix = 'Folder'
Select @cmd = 'dir ' + @path + @folderPrefix + '* /O:n /b' -- order by name, only return filenames
Delete From #t1
Where Outp Is Null -- get rid of the blank row
Declare @num Varchar(4)
Select @num = Right(Outp,4)
From #t1 -- recover last number
Select @num As [last known folder name]--show it
Declare @next Varchar(4)
Select @num = @num + 1
Select @next = Right('000' + @num,4)
Select @next As [next known folder name]--show it
Select @cmd = 'md ' + @path + @folderPrefix + @next
Select @cmd As [cmd to run]
--You can then do something like
Declare @outputFile Varchar(255)
Select Outputfile = @path + 'OutFile.csv'
Select @cmd = 'Move ' + @path + 'OutFile.csv ' + @path + @folderPrefix + @next
--exec xp_cmdshell @cmd
This assumes the root folder is known, 'C:\TestDTS\ in this example and you have created a file in said folder named 'OutFile.csv' The final (commented out) xp_cmdshell call should move it into the newly created numbrered folder for you.
Paste all of the above into a SQL Task called after you have created the file, edit to suit your environment and you should be good to go.
I haven't tested this fully
The numbers are left padded with zeroes to sort properly
This should last at one folder per day for just over 27 years.
http://glossopian.co.uk/"I don't know what I don't know."