troubleshooting Question

Returning filesystem files through SQL Server BLOBs?

Avatar of Member_2_1348041
Member_2_1348041Flag for Ireland asked on
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008
1 Comment1 Solution591 ViewsLast Modified:
Hello boys and girls. First of all, it's important that any suggested solution should work at the very least on SQL Server 2005.

What I need to do seems very simple, but I somehow don't think it is.

What I need is a NATIVE SQL SERVER SOLUTION to this problem. I CAN, however, use things like xp_cmdshell - that is fine

The problem is that I need SQL Server to basically do something like

INSERT
  INTO SomeTable
          (SomeBLOB)
... well, there's my problem. How do I do this? I know that the data is stored in a document somewhere on the server, in location P:\SomePath\SomeDocument.ext

So what I need SQL Server to do is retrieve that data from WITHIN an SP, BLOBify it, and store it into SomeTable

any ideas? Any examples I can find online seem to focus on doing the writing to the BLOB bit from within a calling program. That's not going to cut the mustard ...
ASKER CERTIFIED SOLUTION
Member_2_1348041

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros