April 29, 2009 at 8:51 pm
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!
April 29, 2009 at 9:05 pm
Try here:
http://www.jumpstarttv.com/loading-binary-files-into-sql-server-using-ssis_62.aspx
Registration is free.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply