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 |
|
robertmeet
Starting Member
1 Post |
 Posted - 2014-12-08 : 19:35:14
|
| Hello Everyone.I need to load images from folders into a SQL Server table and I have done it successfully for individual images, however I need to load all the names of the folders and sub folders in separate columns + load all images as well.So the folders look like the example in the screenshot and the final result of the table in SQL Server should look like the second screenshot.Can anyone help with a code that could do this? Thanks in advance for the time.Link to screenshots[url]http://tinypic.com/view.php?pic=ivllkj&s=8[/url][url]http://tinypic.com/view.php?pic=2pt9cg6&s=8[/url] |
|
|
viggneshwar
Yak Posting Veteran
86 Posts |
Posted - 2015-01-09 : 05:58:47
|
| You can use SSIS to import all imagesRegardsViggneshwar A |
 |
|
|
|
|
|
Load Folder name and Images into SQL Tables