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 |
|
henkleppers
Starting Member
2 Posts |
 Posted - 2009-06-17 : 08:53:58
|
| Hi,I have a bunch of PDF files, and I want to store each of them as a seperate record in a SQL 2005 db as BLOB data. Can anyone point me to a mechanism in SSIS that can do that? Second step is to also retrieve metadata from these pdf's and to store that data as fields in the same record as the PDF.Which data transfer components can I best use? How can I retrieve the metadata in my SSIS package and transfer it to fields in a record?Thanx!Henk |
|
|
|
|
|
using SSIS for importing PDF and store it as BLOB