November 11, 2015 at 6:44 am
Hi
we have numerous pictures file of our Products for website. that save and exists on an file server.
And our web site read some data from Database and pictures from File server. we have many problems with that file server , save new file, Network connection , and ...
one solution is to Transfer These files to Database :
1- what steps should be taken?
2- what Difficulties we will encounter ?
3- should we use an interface to next change these files or there is a mechanism to know any file changes and transfer them to database ? (means that office user work with that folders same as old and a mechanism transfer changes to database)
thank you
November 12, 2015 at 8:22 am
i've imported image data from disk via ssis before.
You can use the 'import column' transformation as part of a data flow task to import data from a file to a SQL table.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply