Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

OLE Automation in T-SQL Expand / Collapse
Author
Message
Posted Monday, January 18, 2010 7:49 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, June 2, 2014 9:03 AM
Points: 15, Visits: 57
Hello,

I have been trying to find any resources about OLE Automation in T-SQL. The problem right now is:

I have a file at a location on the server. I want the binary content of the file to be stored in an XML variable and lets say, I want to insert that xml variable in a table (which ofcourse has a column of datatype xml).

I know that this could be done using spOA system stored procedures.
I could find several other things with spOACreate, except any useful resource for 'scripting.filesystemobject'.

Googling or MSDN'in didn't help a bit.

Can any one help me with this please?

Thanks and Regards,
Renuka Prasad.
Post #849173
Posted Monday, September 10, 2012 6:24 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 11:56 AM
Points: 266, Visits: 816
Try this page: http://msdn.microsoft.com/en-us/library/bstcxhf7(v=VS.85).aspx

All the methods, properties, and lots of examples.


Sigerson

"No pressure, no diamonds." - Thomas Carlyle
Post #1356686
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse