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?
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)
1 same as what TG suggested 2 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 SSIS
Sample packages using File System Task and ForEachLoop can be found here
Create Folders using SQL table
Posted - 01/03/2013 : 15:50:06
