I am working with SQL Server 2005 using an Access application as front-end. The application stores .PDF files (as well as other types, such as .JPG), one at a time, in the SQL Server database as image or varbinary(max) using AppendChunk. (Yes, the files themselves do need to be stored in the database, not just links to external locations, since I use Merge Replication to synchronize the contents with remote databases.)
The AppendChunk approach works well for individual files, but I have a large number of folders containing a large number of .PDF files that need to imported. I would prefer to automate this with SQL Server Integration Services instead of coding it in Access using VBA, but I do not know how.
Do you know of a tutorial that discusses all the steps of how to accomplish loading binary files from a single given location (folder) into a varbinary(max) column, retaining the file contents in the same way that AppendChunk does, and also storing each file's name in a text column at the same time? Thanks!