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 |
|
nick_nguyen2004
Starting Member
5 Posts |
 Posted - 2008-02-15 : 23:21:11
|
| Hi, I've read from a topic in this forum saying that we could store PDF files in a hard drive location and import the link into a table of database in SQL server 2005, but i don't know how. So I really appreciate if someone could show me how to write a store procedure or a scripto to do this? And by the way, i have another question. From that PDF files link, is there any way that we could call that pdf files and print that files from SQL script or SQL store procedure. Thanks a lotNick |
|
|
Qualis
Posting Yak Master
145 Posts |
Posted - 2008-02-18 : 10:42:07
|
| You can use a DataFlow in SSIS to import the PDFs as BLOBs into the DB by using an ImportColumn transform. As for printing, you will need to create your own code for that. There isn't a native way in T-SQL to do that. You could create a CLR Stored proc and use some .net PDF lib to do it I suppose. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
nick_nguyen2004
Starting Member
5 Posts |
Posted - 2008-02-19 : 19:50:31
|
| Thanks Qualis and Madhivanan, i'm going to a look at the link that Madhivanan gave me. Thanks guys. |
|
|
|
|
|
|
load pdf into SQL server 2005