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 |
|
ph1long
Starting Member
16 Posts |
 Posted - 2013-01-03 : 15:50:06
|
| Hi,I have filenames such as:FD3_2012-10_Stmt.pdfFD6_2012-10_Stmt.pdfAAA_2012-10_Stmt.pdflisted in a table called "Reports".Is there a way to:1. Create (X) number of random folder names in a table ("X" depends on how many file names I have in the table.2. Use these names to create folders on the C: drive.3. Place the files in their corresponding folders?Thanks |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2013-01-03 : 17:24:20
|
| I assume you are asking for a programmatic solution?1. sounds like you simply want to add rows in one table based on the rows in another table?That is easy with t-sql.2 and 3. These both involve interaction with the file system. The best way to do that is with either application code (ie .net app) or with integrated code solution (ie CLR). .net has Class libraries with functionality to perform these typs of things. (ie System.IO.FileInfo)Be One with the OptimizerTG |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-01-04 : 02:55:39
|
| 1 same as what TG suggested2 and 3 you could use File System Task available in SSIS to create folders. the looping can be implemented by means of ForEachLoop task. Also files can be moved using Move File functionality in SSISSample packages using File System Task and ForEachLoop can be found herehttp://visakhm.blogspot.in/2012/12/selective-file-archiving-using-ssis.htmlhttp://visakhm.blogspot.in/2012/05/package-to-implement-daily-processing.html------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Create Folders using SQL table